PDA

View Full Version : [SOLVED] Solved: Keeping formulas



Tenspeed39355
03-10-2005, 09:28 AM
Is there a way to keep formulas in a ss after I do a copy and paste the ss
to another ss?
Thanks.
Max:bow:

Anne Troy
03-10-2005, 09:30 AM
Have you tried Edit-->Paste special-->Formulas?

mdmackillop
03-10-2005, 04:53 PM
Hi Max,
Your query looks simple , but are you trying to more than Edit/Copy sheet?
MD

Tenspeed39355
03-10-2005, 08:19 PM
Thanks for the reply. Here is what I need to do. I have formulas in the spread sheet. I want to make a copy of the ss to another ss and keep the formulas in the second ss.
What do I do to keep the formulas in the second ss?
Thanks
Max

Brandtrock
03-10-2005, 11:40 PM
Thanks for the reply. Here is what I need to do. I have formulas in the spread sheet. I want to make a copy of the ss to another ss and keep the formulas in the second ss.
What do I do to keep the formulas in the second ss?
Thanks
Max

Right click the sheet tab and choose Move or Copy. Click Create a Copy on the pop up window and select New Workbook from the dropdown for location. This will duplicate your sheet, formulas and all.

HTH

Tenspeed39355
03-11-2005, 07:20 AM
To HTH Thanks that fixed my problem
Max

Brandtrock
03-11-2005, 07:42 AM
To HTH Thanks that fixed my problem
Max

Man I gotta quit adding that at the bottom.
:beerchug:
Kindest regards,

Zack Barresse
03-11-2005, 09:24 AM
Also, if doing so in code, this is probably even easier! ...
Sheets("Sheet1").Copy
That's it! FYI.