Auto-update row numbers after inserting new row
Thanks for your response, Pete. I have tried the Row() feature also. But I
need some way [if it exists! ;-)] to have the row numbers automatically
update after the new row is added. The spreadsheet is being used by people
that really don't have a clue what to do with Excel, and the SAS program that
will be reading the spreadsheet requires the correct row number be in the
spreadsheet.
Cheryl
--
carusso
"carusso" wrote:
I have a spreadsheet with Column A numbered sequentially using auto fill
series. If someone adds a new row between 2 existing numbered rows, is there
any way to automatically update the row numbering?
Thanks!
--
carusso
|