Rob, not sure if it works in 2003 but works in 2007/2010. If you have data in 4 rows in column G2 to G5 add the formula to H2 (=G2+1) and drag it down to H5 when you enter a new number to G6 the formula will automatically follow, so no need for macros. In the file advance option settings you must have the "Extend data range formats and formulas" option selected on.