Ask a questionAsk a question
 

AnswerText change after insert / delete row

  • Monday, October 12, 2009 8:45 AMCancer_cme Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I need to create (using excel 2007) a column containing a special id pattern : test01,test02,..... and so on. what is the best way this column get modified after every insert/delete rows. That's to say, if i include a new row between test01 and test02, i want the new row to initialize to test02 and the one after becomes test03 and so on for the following cells to be incrementing.

Answers

All Replies