Auto-update row numbers after inserting new row
Well, unfortunately, I can't guarantee they would enable macros. If they see
the dialog box to enable/disable macros (which as a default...most probably
still have this feature turned on), it probably scares them and they click
"disable"...lol
--
carusso
"Pete_UK" wrote:
Well, to do that you would need a macro, and if you do a Google search
I'm sure you will find many suggested.
But, if you go that route and if your users are not very competant
with Excel then how could you ensure that they would enable macros to
run when they start Excel?
Pete
On Jan 26, 4:03 pm, carusso wrote:
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- Hide quoted text -
- Show quoted text -
|