based on the value in the column "Cost Centre" (input is file with 1) at the beginning
Output is as many files as there are values in the column "Cost Centre"
Files should be like the 2 examples files with "2" at the beginning
Pivot tables should be maintained and refreshed in all files
Output files should be saved in same folder as input file
Real input file has around 500,000 lines and 7,000 values in "Cost Centre" colum
(so the output is around 7,000 excel files)
13 freelancers are bidding on average $101 for this job
Hello! I can create the 7000 files using a VBA script. I am available and I can finish in 2-4 days. You will not be dissapointed, I have a big 30% rehire rate. Thank you!
Hi there, I have read your requirements and can do this work accurately and fast as you need in separate Excel files accurately and fast as I am expert in Excel. Please message me so that we can talk. Thanks
Hi, Can you please send me the example of your file? I want to make one cost center example for you. And you'll see, so you can decide then. Waiting for your reply. Thanks
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.