View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Floyd107
 
Posts: n/a
Default Incrementing numbers

Hi group,

I need to enter a number in a cell and have other cells in the worksheet
update automatically from the base number.

Initial number -
BR06/0358

Output required each in different cells-
BR06/0358/1
BR06/0358/2
BR06/0358/3 etc. etc. up to maximum /12

Any help would be greatly appreciated. If it makes it any easier the initial
number could be input as BR06/0358/0 although I'd prefer not to.

I'm using excel 2000

Thanks
Martin