KashLeeC
06-09-2011, 11:14 PM
I currently have a folder with a varying amount of files in it. In each file is one sheet's worth of data with an unknown amount of rows.
With the master page open, I would like to copy all of the file's single sheets each to a new sheet in the master workbook, renaming the worksheet as the old files name.
Any help would be great guys!
With the master page open, I would like to copy all of the file's single sheets each to a new sheet in the master workbook, renaming the worksheet as the old files name.
Any help would be great guys!