Solved: Keeping formulas

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:

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

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

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

Quote:

---

Originally Posted by 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

---

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

To HTH Thanks that fixed my problem
Max

Quote:

---

Originally Posted by Tenspeed39355

To HTH Thanks that fixed my problem
Max

---

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

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