Consulting

Results 1 to 8 of 8

Thread: Solved: Keeping formulas

  1. #1

    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

  2. #2
    Site Admin
    The Princess
    VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Have you tried Edit-->Paste special-->Formulas?
    ~Anne Troy

  3. #3
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Hi Max,
    Your query looks simple , but are you trying to more than Edit/Copy sheet?
    MD

  4. #4
    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

  5. #5
    VBAX Mentor Brandtrock's Avatar
    Joined
    Jun 2004
    Location
    Titonka, IA
    Posts
    399
    Location
    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

  6. #6
    To HTH Thanks that fixed my problem
    Max

  7. #7
    VBAX Mentor Brandtrock's Avatar
    Joined
    Jun 2004
    Location
    Titonka, IA
    Posts
    399
    Location
    Quote Originally Posted by Tenspeed39355
    To HTH Thanks that fixed my problem
    Max
    Man I gotta quit adding that at the bottom.

    Kindest regards,

  8. #8
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,892
    Location
    Also, if doing so in code, this is probably even easier! ...
    [vba]Sheets("Sheet1").Copy[/vba]
    That's it! FYI.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •