David Bussell
New Member
- Joined
- Jun 2, 2009
- Messages
- 22
I have 5 sheets in each of 20 workbooks (the sheets names are common in each workbook). For instance the sheets are called – Tom, Anne, Tim, Paul and **** and rather than merge the data from the sheets named Tom, I would like to merge the data from the sheets name Paul.
I have managed to compose a macro to merge the data from each workbook into a single workbook, with the merged data from each workbook appearing under the last row relating to the previous workbook.
However it only works for the first sheet in each workbook.
What code should I write, before the
'For i = 1 To .FoundFiles.Count'
To be able to choose the sheet. (or am I on the wrong track?)
DB
I have managed to compose a macro to merge the data from each workbook into a single workbook, with the merged data from each workbook appearing under the last row relating to the previous workbook.
However it only works for the first sheet in each workbook.
What code should I write, before the
'For i = 1 To .FoundFiles.Count'
To be able to choose the sheet. (or am I on the wrong track?)
DB
