• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to Insert New Row and Update =Row() formula

Matt F

New Member
I have two data tables on a worksheet with Auto Numbering (1,2,3,…) in the first column.
I am using =Row() –<row#> to auto populate these numbers.
When I add a new row to the first table it throws the numbering sequence off in the second.
Is it possible to create a macro that will insert a new row in the first table and update the =Row-<row# +1> formula in the second table so both tables will be correct?
 

Attachments

  • Multiple Tables New Row.xlsm
    18.7 KB · Views: 7
dEAR Matt F

Pls use =ROW()-3 in in table 1.

Wihile your macro doesn't make changes in table 2 however you may use.
=ROW()-MAX(Table1[[#All],[ID]])-6
 
Back
Top