Excel 2002 Create Workbook (merge/reformat)?

  • Thread starter Thread starter ~Dave~
  • Start date Start date
D

~Dave~

I have 12 seperate spreadsheets I want to combine into 1 workbook (12 tabs).
Any other alternative ways to do this other than copy and paste? Need to
reformat "most" of the worksheets, I assume this can be done if all 12 tabs
are selected. I may have to do this several times otherwise I would just
copy and paste. Each spreadsheet has an average of 3k-4k transactions.
 
You can open the workbook, ctrl-click on the worksheet tab and drag that
worksheet into another workbook.

(Then close that "sending" workbook and open the next...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002 Create Workbook from 123.... 1
CTL-END not working as expected 4
How to duplicate a chart that relies on dynamic named ranges 2
Excel 2003 - VBA - Closing workbooks without error 4
Listing only sub totals in pivot table 1
Creating a workbook(s) based upon a cells value <--HELP please 3
Copy/Paste from one workbook to another not recognized by formulas 2
Paste link only - not value 4

Back
Top