I need to create a file where there is 1 master worksheet and based on a system (it can be 1 column with a number put in 1,2,3,4,5,6,7,8,9 etc.. it will then take all the data of that row and populate a different worksheet in the same file ( so all the data gets entered into the master worksheet and then gets split up into the appropriate other sheets based in the number put into one of the columns in the master. I would need 1 master and 12 to 15 break outs for the sheet. can use numbers or letters or whatever to categorize the sheet.
This will be a growing sheet worksheet so it needs to be able to keep sorting the data to separate sheets as i add rows.
I will also need the ability to sort any of the sheets based on the columns there. and add new columns to the master (the column names will be the same on all the sheets..it is just an auto sorting feature to break up the master into the others..
There might be a 2nd filter based on Text color.. the idea is the master might belong to 2 people (or more in the future) so all of the Green colored text with "1" go to worksheet A , blue colored text with "1" go to worksheet B..
I can help create a skeleton if needed but I wanted to see if this can be flexible first.
Bu iş için 31 freelancer ortalamada $46 teklif veriyor
Exceptional quality & Quick work. Please refer to Profile & Reviews for quality of work. Thanks FAZ
Greetings, It's a pleasure if ever i can do business with you. Please check my PMB. Thanks Paul
Hello Sir, I can help you on this project because I have experience working with excel macros. Thanks
Lots of Excel macro experience looking forward to starting
I am very interested in this job. I had been using Microsoft Excel for almost 8 years so I am proficient in using Excel.
I'm very good at automating Excel with VBA. This seems easy. Give a new guy a chance! you wont regret it.
Hi I am ready to start this project. Please let me know more details about this project. Thank You Zabunnesa
I have developed several Excel applications using extensive VBA for data import/export, manuipulation of data and spreadsheets, and web scraping. All parts of your project are definitely possible, including the subordi Daha Fazla