Solved: Keeping formulas

[Tenspeed39355]

Is there a way to keep formulas in a ss after I do a copy and paste the ss
to another ss?
Thanks.
Max

[Anne Troy]

Have you tried Edit-->Paste special-->Formulas?

[mdmackillop]

Hi Max,
Your query looks simple , but are you trying to more than Edit/Copy sheet?
MD

[Tenspeed39355]

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]

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]

To HTH Thanks that fixed my problem
Max

[Brandtrock]

To HTH Thanks that fixed my problem
Max

Man I gotta quit adding that at the bottom.

Kindest regards,

[Zack Barresse]

Also, if doing so in code, this is probably even easier! ...
[vba]Sheets("Sheet1").Copy[/vba]
That's it! FYI.