Thread: Continuous Invoice Nos.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jaleel.k.mohammed@gmail.com is offline
external usenet poster
  
Posts: 4
Default Continuous Invoice Nos.
Hi,

I have an invoice number in cell A1 of a sheet like ADD/01/2190/2015. When I drag this number I wish to get the next invoice number in cell A2 as ADD/01/2191/2015 and in cell A3 as ADD/01/2192/2015 and so on. Can anybody suggest a formula for this?

Regards,

Jaleel
Reply With QuoteReply With Quote