Get number in cell add to it and put back in same cell

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have files that I need to insert or delete x number of lines from. When I
do I need to fix index values in the file that are values in a certain
column. for example
Cell F10 has a 8
F11 has a 9
F12 has a 20
F13 has a 15

If I insert 5 lines between line 11 and 12 I need to add 5 to F12 and F13 etc.
There might be a way to do this but i'm unsure.
Thanks,
 
Hi Dave;

in the spreadsheet you could use this formula

=ROW(A1)

This would provide the row number for the first cell.

If you can write macros you can use

activecell = activecell.row

I hope it helps,

Greg
 
Back
Top