copy sheets

P

Pammy

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?
 
M

MrReeLady

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
 
P

Pammy

This copied all the sheets into another workbook, I wanted a master with all
the information from the 85 worksheets copied on one master.
 
Top