+ Reply to Thread
Results 1 to 3 of 3

Copying formulas to different sheets

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    Baton Rouge, LA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Copying formulas to different sheets

    Ok here is my issue. I created a schedule for a manager to use. While it tallies a lot of stuff, they do not want employees to see all of this. So I created a new sheet that will transfer only employees' clock in/clock out time. Then, when I did that the formula was something like: =Sheet1!A8. Well, it put 0's in spots that I needed blank. So I figured out this formula to fix that: IF(Sheet1!$A$8="","",Sheet1!$A$8). This works perfectly except I have the first formula input in over 800 cells with different cell references but when I copy and paste the new formula, it keeps the A8 reference instead of updating to the formula I currently have in the cell. Is there a way to keep me from having to input the new formula in 800 cells manually? Sorry if this is confusing, I will try to elaborate.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,505

    Re: Copying formulas to different sheets

    Do it like this in cell A8 of the second sheet:

    IF(Sheet1!A8="","",Sheet1!A8)

    Then you can just copy/paste that anywhere else and the cell reference will change as appropriate.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    07-15-2013
    Location
    Baton Rouge, LA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Copying formulas to different sheets

    So basically I don't need the $'s?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying formulas/pictures between sheets
    By mcphatty in forum Excel General
    Replies: 2
    Last Post: 05-14-2009, 04:26 PM
  2. Copying New sheets using formulas involving previous sheets
    By mcsc03 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-09-2008, 06:01 PM
  3. Copying Excel sheets with all formulas
    By Hesham.Sharara in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2007, 06:25 AM
  4. [SOLVED] Copying Excel formulas between sheets
    By Hoz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-06-2006, 05:00 PM
  5. [SOLVED] Copying formulas referencing multiple sheets
    By JA in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2006, 08:25 PM

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