View Single Post
  #1   Report Post  
E Martin
 
Posts: n/a
Default insert a formatted row in excel [office for xp 2002]

I have a inventory list, in which serveral columns are using validation
[Catergory, item,description, room,] in order to make the list more
efficient, I would like automatically add a row with the same validations,
once you press the enter key at the last column[RECEIPT].
example below:

QTY CATERGORY ITEM DESCRIPTION ROOM AGE 100% RECEIPT