David123456
New Member
- Joined
- Jul 16, 2014
- Messages
- 48
Can anyone assist with a formula.
Take a list of workbooks ( only1 worksheet in each workbook) say the workbooks are held in the y:\ and called 1980-001,1980-002 up to 1980-250
I want to copy all these individual workbooks to one workbook in tabs in file number order.
So the first tab would be 1980-001 the next tab would be 1980-002 and so on depending o how many workbooks there are.
My formula doe this but does not add the workbook name to the tab and also does not copy them over in number order.
Any help greatly appreciated
Take a list of workbooks ( only1 worksheet in each workbook) say the workbooks are held in the y:\ and called 1980-001,1980-002 up to 1980-250
I want to copy all these individual workbooks to one workbook in tabs in file number order.
So the first tab would be 1980-001 the next tab would be 1980-002 and so on depending o how many workbooks there are.
My formula doe this but does not add the workbook name to the tab and also does not copy them over in number order.
Any help greatly appreciated