I have multiple excel files each with multiple sheets that contain the same format with different data in each, unfortunately, files were created like tables and need a lot of time to get data from them...
What is needed is to have a VBA that can create a new tab in the file which contains all the data that are in the other sheets and it can be converted to a pivot table for easy data extraction...I'm attaching the file (example of original) and the needed output.
Project is needed in one day time if that will suit you, please bid.
I have understand the project requirement & interested to work for this project. I will start right now and I will do it before your time . Please send a message so we can discuss more & start the project. Thanks
12 freelancers are bidding on average $29 for this job
Hi, I can do this project right now with 100% accuracy. Sir, I am an expert in a recording of macros on an urgent basis. Sir If you need any sample please let me know. Thanks!
With the experience I have in this type of work, I can guarantee that your requirements can be met, so that the data is in a suitable way to be used in pivot tables.