Results 1 to 4 of 4

Formula incrementing during copy process

Threaded View

  1. #1
    Registered User
    Join Date
    09-20-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    3

    Formula incrementing during copy process

    Apologies in advance if this has previously been answered. I did search through previous queries to see if I could find the solution I require, but could not find the solution

    I have a formula which exists over 4 rows on a summary sheet, this is fed from information from other sheets (Sat through Fri). I now need to copy this down the page ( example attached), unfortunately, using either drag or copy paste increases the "Row" numbers (on the example 98,99,100) by 4 instead of 1 i.e. it will jump to 104 on the next copy.

    I would be looking to continue the formula down the sheet e.g. next would be required to be
    =Sat!G101
    =IF(Sat!E101="M",(Sat!V101-J384),(0))
    =IF(Sat!E101<>"",(0),(Sat!V101-J384))
    =IF(Sat!E101="D",(Sat!V101-J384),(0))

    however, when copying it will just jump to =Sat!G104.......etc

    Any suggestions would be gratefully received.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I copy across incrementing row but not column?
    By mattsk42 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2015, 02:55 PM
  2. Copy formulas horizontally while incrementing vertically
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2014, 08:08 AM
  3. [SOLVED] Copy paste without incrementing - can't use absolute references
    By loulite in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2014, 05:21 PM
  4. [SOLVED] copy the same pattern repeatedly while incrementing down only 1 row
    By tiger10012 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-26-2013, 01:36 PM
  5. how to copy formula incrementing sheet number
    By aguilar25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2011, 04:35 PM
  6. Copy Formula (Transpose) Cells While Incrementing Cells by 4
    By OHPats69 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-27-2006, 06:37 PM
  7. [SOLVED] How do you copy a formula without incrementing some constants?
    By JohnT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2005, 10:06 AM

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