Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 310
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,986
Default 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!

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,986
Default 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!

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 310
Default 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!



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default 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!



  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,986
Default 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!

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 310
Default 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!




  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default 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!






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Coping Dates from workbook to workbook Kenny Excel Discussion (Misc queries) 2 October 7th 07 07:42 AM
coping worksheets with hyperlinks Jackson New Users to Excel 1 August 28th 07 10:20 AM
How do I create a first page index of worksheets in my workbook? Sam Excel Worksheet Functions 7 August 26th 07 04:52 PM
COPING FULL PAGE PATTENS TO ANOTHER PAGE alec Excel Worksheet Functions 1 November 29th 06 06:10 AM
How to print multiple worksheets in one workbook on the same page. rrdiorio Excel Discussion (Misc queries) 2 January 7th 05 12:40 AM


All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"