Coping page set up to other worksheets within the same workbook
 

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!

Coping page set up to other worksheets within the same workbook
 

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

On Thu, 27 Dec 2007 10:27:05 -0800, Michelle
wrote:

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!

Coping page set up to other worksheets within the same workbook
 

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

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

"Michelle" wrote:

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!

Coping page set up to other worksheets within the same workboo
 

Forgot the quote marks for the name.

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


"JLGWhiz" wrote:

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

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

"Michelle" wrote:

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!

Coping page set up to other worksheets within the same workboo
 

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

"JLGWhiz" wrote:

Forgot the quote marks for the name.

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


"JLGWhiz" wrote:

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

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

"Michelle" wrote:

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!

Coping page set up to other worksheets within the same workboo
 

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

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


"Michelle" wrote in message
...
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

"JLGWhiz" wrote:

Forgot the quote marks for the name.

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


"JLGWhiz" wrote:

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

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

"Michelle" wrote:

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!

Coping page set up to other worksheets within the same workboo
 

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.

"Michelle" wrote:

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

"JLGWhiz" wrote:

Forgot the quote marks for the name.

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


"JLGWhiz" wrote:

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

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

"Michelle" wrote:

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!

Coping page set up to other worksheets within the same workboo
 

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

"Mike Middleton" wrote:

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

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


"Michelle" wrote in message
...
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

"JLGWhiz" wrote:

Forgot the quote marks for the name.

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


"JLGWhiz" wrote:

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

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

"Michelle" wrote:

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!

Coping page set up to other worksheets within the same workboo
 

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.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Michelle" wrote in message
...
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

"Mike Middleton" wrote:

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

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


"Michelle" wrote in message
...
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

"JLGWhiz" wrote:

Forgot the quote marks for the name.

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


"JLGWhiz" wrote:

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

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

"Michelle" wrote:

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!