copy sheets
This copied all the sheets into another workbook, I wanted a master with all
the information from the 85 worksheets copied on one master.
"MrReeLady" wrote:
Make sure you open a new book to save to first, then...
From your master, right click on one sheet, choose
Select all sheets
Choose Move or Copy
Then choose Book 2 or whatever you named it....
Voila
"Pammy" wrote:
I have 85 worksheets all formatted the same - 4 columns and each sheet has
different row amounts. I want to have one master spreadsheet with all the
information from the 85 worksheets. Can this be done?
|