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! |
All times are GMT +1. The time now is 06:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com