+ Reply to Thread
Results 1 to 3 of 3

Need help - Copying and pasting worksheets / formulas

  1. #1
    Registered User
    Join Date
    08-31-2012
    Location
    Florida, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Need help - Copying and pasting worksheets / formulas

    I have created 2 worksheets for my business tax for 2012

    1- sales log by month
    2 - Cost of sale / P&L

    There are formulas in place linking info from 1 to cells in 2

    I want to create a set of the same worksheets for myself, which will show my actual tip amount (restaurant). My questions are:

    Will the new worksheets' formulas point to doc 2 in original set or will they be separate, pointing to new copied doc?
    If I wanted to do the same for 2010 & 2011 would they then point to original also?

    Thanks
    Confused idiot

  2. #2
    Registered User
    Join Date
    08-31-2012
    Location
    Florida, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Need help - Copying and pasting worksheets / formulas

    ......agh, I realized I can simplify this a little by merging the tabs from sheet 1 onto sheet 2. How do I do that without losing the formulas that link the 2 sheets? Is there a quick way? Or do I have to copy each tab and paste it separately (assuming formulas wont get lost)

    Then above post applies for creating copies.

    So sorry for the confusion. I appreciate anyone's benevolent help in advance.

  3. #3
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Need help - Copying and pasting worksheets / formulas

    Select the cells you want to move. Drag them with the mouse towards the sheet tabs. Hold down the ALT key and drag onto the target sheet tab, while keeping the left mouse button down. The target sheet will open and, still keeping the left mouse button down, you can drag the cells to their new positions on the target sheet. The cell references will adjust.
    Like a post? Click the star below it!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1