Hello,
This is my first post here.
I have many workbooks, each with various number of sheets.
Each sheet has two columns I need to cut and paste into a new workbook.
I need to append each new cut and paste to the bottom of each old cut and paste. So I am basically stacking the data from the sheets into this new workbook.
Is this possible?
I appreciate any advise.
I have read that I should load my books for people to help me, but my work has told me the data is proprietary, so that would be a big violation I can not do. I am hoping there may be a general formula I can utilize and adapt. A template of sorts.
To recap: I have Workbooks 1,2,3,4,...n
Each workbook has sheets, 11,12,13,...1n
each of those sheets has two columns (A,B) that I need to cut and paste into a new workbook.
So the new workbook would have one sheet that had all that new info and it may look something like this:
11A, 11B
12A, 12B
1nA, 1nB
2nA, 2nB
Thank you
Bookmarks