A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Losing Print format when copying wrksht to wrksht or wkbook to wkb



 
 
Thread Tools Display Modes
  #1  
Old November 17th, 2009, 03:18 PM posted to microsoft.public.excel.misc
MK
external usenet poster
 
Posts: 87
Default Losing Print format when copying wrksht to wrksht or wkbook to wkb

We have a file with about 30 worksheets in it. Each is a "quickie" quote and
when we save it (to make changes or for history), we copy the entire
worksheet to a new file, and save it with a new name.

The new file doesn't bring with it the print parameters, and we have to
start over (inserting a picture, custom heading, page layout, etc).

How can we get the print parameters from the first file ("generic quotes")
to the 2nd file ("John Smith's quote file")?
  #2  
Old November 17th, 2009, 03:59 PM posted to microsoft.public.excel.misc
FloMM2
external usenet poster
 
Posts: 189
Default Losing Print format when copying wrksht to wrksht or wkbook to wkb

MK,
Have you tried this:
1) Setting up a template
or
2) Saving the first file "generic quotes" as a Save As "John Smith's quote
file"
hth

"MK" wrote:

We have a file with about 30 worksheets in it. Each is a "quickie" quote and
when we save it (to make changes or for history), we copy the entire
worksheet to a new file, and save it with a new name.

The new file doesn't bring with it the print parameters, and we have to
start over (inserting a picture, custom heading, page layout, etc).

How can we get the print parameters from the first file ("generic quotes")
to the 2nd file ("John Smith's quote file")?

  #3  
Old November 17th, 2009, 05:24 PM posted to microsoft.public.excel.misc
MK
external usenet poster
 
Posts: 87
Default Losing Print format when copying wrksht to wrksht or wkbook to

I thought about "save as" as an option; but then, I'd have to delete all the
worksheets (but the 1 or 2 relevant ones) from the new file (or every quote
would have 30 sheets, and I wouldn't know which one the customer was
interested in 30-60 days down the road. I can try the template idea. Would
I insert the worksheet into the template file - then save the template file
as "John Smith"?

"FloMM2" wrote:

MK,
Have you tried this:
1) Setting up a template
or
2) Saving the first file "generic quotes" as a Save As "John Smith's quote
file"
hth

"MK" wrote:

We have a file with about 30 worksheets in it. Each is a "quickie" quote and
when we save it (to make changes or for history), we copy the entire
worksheet to a new file, and save it with a new name.

The new file doesn't bring with it the print parameters, and we have to
start over (inserting a picture, custom heading, page layout, etc).

How can we get the print parameters from the first file ("generic quotes")
to the 2nd file ("John Smith's quote file")?

  #4  
Old November 17th, 2009, 06:49 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Losing Print format when copying wrksht to wrksht or wkbook to wkb

How are you copying the worksheet to the new workbook?

If you right-click on the tab and "move or copy" and "create a copy" to new
book. the print settings should go with the worksheet.


Gord Dibben MS Excel MVP

On Tue, 17 Nov 2009 06:18:01 -0800, MK wrote:

We have a file with about 30 worksheets in it. Each is a "quickie" quote and
when we save it (to make changes or for history), we copy the entire
worksheet to a new file, and save it with a new name.

The new file doesn't bring with it the print parameters, and we have to
start over (inserting a picture, custom heading, page layout, etc).

How can we get the print parameters from the first file ("generic quotes")
to the 2nd file ("John Smith's quote file")?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:06 PM.


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