Automatically update formula

Posted by paul.malcolmpip... PM | on Fri, 06/03/2009 - 12:42 4799 10 comments | report

I currently have an Excel spreadsheet where I have a row number in column "A" running down the spreadsheet.
Is there a way that I can get excel to automatically update this number, (and also subsequent row numbers) after a row has been inserted?Any help gratefully received.
Thanks,
Paul Caddick

Comments

There are 10 comments. Login or register to view them.

Automatically update formula

Anonymous | Sat, 14/03/2009 - 16:28

Renumbering after Inserting a row

Anonymous | Fri, 13/03/2009 - 16:34

Simple solution

b.potter | Fri, 13/03/2009 - 14:59

Silly Question

chris.lee99 | Fri, 13/03/2009 - 13:12

Use =row()

David160 | Fri, 06/03/2009 - 16:56

Heavy handed VBA option

ACDWebb | Fri, 06/03/2009 - 14:20

autoupdate =CELL("row",A1)

listerramjet | Fri, 06/03/2009 - 16:00

=CELL("row"A1)

paul.malcolmpiper.co.uk | Fri, 06/03/2009 - 13:35

It all depends!

adam.arca | Fri, 06/03/2009 - 13:30

how about

listerramjet | Fri, 06/03/2009 - 13:23