copy worksheet containing form

  • Thread starter Thread starter Roy Schultz
  • Start date Start date
R

Roy Schultz

I have several worksheets which I use to print delivery forms that have been
provided by vendors for national accounts. Each time the vendor changes a
different workbook must be opened.
What I would like to do is consolidate all these forms into one workbook.
How can I copy the entire worksheet including all spacing, merged cells, etc
into a different workbook?
 
Start a new workbook.

Open up one of the existing workbooks.
Select the sheets you want to copy into your new workbook.
(Click on the first and ctrl-click on subsequent)

Then Edit|Move or Copy Sheet
Select your new book in the "To book" box
And "(move to end)" in the before sheet box.

If you want to copy the sheet, check that box at the bottom.

You can also see this dialog by rightclicking on the worksheet tab.

=====
Another option that does the same thing.

Start your new workbook.
Open all the other workbooks.
Window|Arrange|tiled.

Select the sheets to move/copy and just drag them over to the new workbook.
If you want to copy them, hold the ctrl key when you drag.
 
Can also just select 'New Book' in the 'To Book' field, which saves having to
get rid of the default sheets in a new book if you create it first.
 
Back
Top