Tricky Cut & Paste combo
Posted by Paul Allen on May 23, 2000 7:52 AM
I need help please.
I need a macro that can "cut" information from 2 separate workbooks and paste onto a new workbook.
The complexity is that in both workbooks the data needed is in sections and the amount of data sections can vary .
However there is uniformity, each section of data is 10 rows in length (eg R6-R15) and 7 columns wide (eg A-G). There is also a space (1 row) between each section.
I need the Macro to start at the top of the 2 workbooks and find the first section of data cut and paste onto new workbook, then go back to the 2 workbooks and find the next section of data, again cut and paste onto new workbook - except paste onto a new sheet. Then to go back to the 2 workbooks, find the next section and cut and paste in new workbook on another sheet. This should go on until all data sections have been cut.
At the end there should be 3 workbooks, 2 with no data any more and 1 with all the data spread over multiple sheets.
PS the pasted data in new workbook needs to be spaced apart ( eg A5:G14 & A16:G25).
It's a tricky one and hard to explain. I hope it is clear anyone brave enough to take a stab at!