Is there a way to keep formulas in a ss after I do a copy and paste the ss
to another ss?
Thanks.
Max
Is there a way to keep formulas in a ss after I do a copy and paste the ss
to another ss?
Thanks.
Max
Have you tried Edit-->Paste special-->Formulas?
~Anne Troy
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
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.Originally Posted by Tenspeed39355
HTH
Brandtrock
To HTH Thanks that fixed my problem
Max
Man I gotta quit adding that at the bottom.Originally Posted by Tenspeed39355
Kindest regards,
Brandtrock
Also, if doing so in code, this is probably even easier! ...
[vba]Sheets("Sheet1").Copy[/vba]
That's it! FYI.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables