Coping page set up to other worksheets within the same workbook

M

Michelle

I'm creating a form worksheet that will be repeated 84 times. Is there a way
that I can copy this same form into each tab without having to do a page set
up for each worksheet? Each tab represents one filing cabinet number and the
form is for a Record Inventory. This form is just one page with merged cells,
column headings etc.

Thanks!
 
G

Gord Dibben

Rather than copying the Form to 84 worksheets, copy the worksheet 84 times.

The original print setup will be retained for each copied sheet.


Gord Dibben MS Excel MVP
 
J

JLGWhiz

The standard copy method for a worksheet should carry everything over.
Sample code below.

Worksheets("myForm").Copy After:=Worksheets("myForm")
ActiveSheet.Name = myForm2
 
J

JLGWhiz

Forgot the quote marks for the name.

Worksheets("myForm").Copy After:=Worksheets("myForm")
ActiveSheet.Name = "myForm2"
 
M

Michelle

Please forgive my inexperience but I don't understand what you mean by
"myform". Perhaps I should have said I was trying to copy the same worksheet
over and over again but within the same workbook. Any suggestions? I tried
the select all, copy, paste special, all, but the page setup isn't staying
with the copy. I have it set up for landscape, headers, footers etc and none
of that is like I set it up on the first page.

Thanks, Michelle
 
M

Mike Middleton

Michelle -
Perhaps I should have said I was trying to copy the same worksheet over
and over again but within the same workbook. Any suggestions? <
Click to expand...

Edit | Move or Copy Sheet | Create a copy ...

Or, right-click the sheet tab, ...

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 
J

JLGWhiz

Sorry Michelle, I am used to posting in the programming group. What I gave
you was two lines of code using "myForm" as the worksheet name. Essentially,
it says that all you have to do is copy the worksheet 84 times and anything
that is in the original sheet will be in the copy. It takes, controls, code,
formulas, format and data all from the original sheet to the copy. It would
be real fast with a macro, but since you are not familiar with VBA, I guess
Mike Middleton's suggestion is probably the way to go.
 
M

Michelle

My life saver!!!! Thank you 84 times over again! That did the trick and I
appreciate all of the responses. I've been playing with Excel for years and
have just started to really dig into what this program can do. I took my
specialist certification from MS a few weeks ago and passed but I can tell I
have a long way to go before I can be an expert.

Thanks again to all who replied!
Michelle
 
R

RagDyer

The *easiest and quickest* way to duplicate (copy) a sheet within the same
WB is:

Click on the sheet tab you wish to copy,
Hold down <Ctrl>,
Then, drag the tab left (or right), just so the tiny sheet icon clears the
tab border,
Release the mouse,
Release <Ctrl>.
 
Top