I have 12 Excel workbooks (attached follows one of those). Each workbook contains hundreds of worksheets with data (i.e., 40 to 60 rows per worksheet).
What I need: to have the data in each of those worksheets located in just one worksheet, for each workbook.
For instance: if "worksheet 1" contains data from rows 2 to 40, and "worksheet 2" contains data from rows 1 to 50, data from "worksheet 2" would be arranged immediately after the data in "worksheet 1". So, the first row of data in "worksheet 2" would be put after the 40th row of data in "worksheet 1", that is, on the 41st row. The first row of data in "workbook 3" would be put after the last row of data that was located in "workbook 2" but that was moved to "worksheet 1", and so on.
The end product would be 12 workbooks and each workbook would contain only one worksheet with all the data in it.
I simply do not have time to copy and paste data from thousands of worksheets and stack them into one. This process can certainly be automated, but I don't know how to do it. Besides, doing so manually can always lead to mistakes. I'd like you to automate the "copy and paste" process and make sure the data is arranged properly.
Let me know if my needs are unclear.
The job shouldn't take long to do if it's automated, quite the contrary. Because of that, I'm uncertain about how much to ask for it. An hourly rate seems the best option.
Posted On: March 09, 2017 07:15 UTC
Category: Admin Support > Data Entry
Skills: Excel VBA, Microsoft Excel
Country: United States
click to apply
Apply Now: All jobs | upwork.com http://bit.ly/2mnVhuC
No comments:
Post a Comment