+ Reply to Thread
Results 1 to 5 of 5

copy and past down formulas

  1. #1
    Registered User
    Join Date
    05-17-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    38

    copy and past down formulas

    Hi,
    I am trying to copy and paste a formula down but when I go down two lines in my the calc sheet I need the formula to go just one line down on the workings tab
    example

    In cell M6=IF(LM!F5<0,LM!E5,LM!D5).
    In M7 and M8, I have a few calculations
    When I past the formula from M6 in M9, I need =IF(LM!F6<0,LM!E6,LM!D6)
    However, Excel brings =IF(LM!F8<0,LM!E8,LM!D8)

    Any ideas?

    Best Regards,
    Josvill

  2. #2
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: copy and past down formulas

    M9 = =if(indirect("lm!f"&row()-1)<0,indirect("lm!e"&row()-1),indirect("lm!d"&row()-1))
    Don`t care, take care...

    Regards,
    Mangesh

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,250

    Re: copy and past down formulas

    TRY

    =IF(INDIRECT("lm!f"&ROW()/3+3)<0,INDIRECT("lm!e"&ROW()/3+3),INDIRECT("lm!d"&ROW()/3+3))

    Assumptions is pattern of rows 6.9,12 etc

  4. #4
    Registered User
    Join Date
    05-17-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: copy and past down formulas

    thanks Mangesh/John, when dragging down it doesn't do what I expect
    I am uploading an example now.
    I am also trying to replicate the same rule for T6. but to not avail.
    Could you give me a hand please?Testing template formula.xlsx

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,250

    Re: copy and past down formulas

    If you drag the formula down you are going to replace M7 and M8 with the one in M6.

    In M7 and M8, I have a few calculations

    in M6

    =IF(INDIRECT("lm!f"&INT(ROW()/3)+3)<0,INDIRECT("lm!e"&INT(ROW()/3)+3),INDIRECT("lm!d"&INT(ROW()/3)+3))

    will place same formula in 6, 7 and 8 if dragged down

    And rows 9, 10 and 11 will have next increment of "F"

    now very confused.

+ 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. [SOLVED] Seeking formulas tor Billing Statement to calculate Past Due 30, 60, 90, 120 days
    By ElmerFud in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-30-2015, 02:47 PM
  2. [SOLVED] Copy from Excel to Reflection, simple Copy & past script ... Help Please : )
    By strik009 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2015, 02:15 PM
  3. Help with copy past to last used row +1
    By Pat1009 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-11-2015, 02:12 PM
  4. Copy, past, formulas, loop
    By Aftermaind in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-13-2014, 08:24 AM
  5. [SOLVED] need help with copy past vba
    By K-Ching in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2014, 01:16 PM
  6. [SOLVED] Macro to delete formulas extended past data set
    By mcranda in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-25-2013, 05:49 PM
  7. How to past formulas without updating external links
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2005, 08:05 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