Continuous Invoice Nos.

[jaleel.k.mohammed]

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

 

[GS]

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

Easiest way, IMO, is swap positions of year and invoice# so normal drag
will fill as a series.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Claus Busch]

Hi Jaleel,

Am Sun, 1 Feb 2015 21:11:09 -0800 (PST) schrieb
(e-mail address removed):

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?

if you cannot change the postition of the number and the year try in A2:
="ADD/01/"&ROW(A2191)&"/2015"
and copy down


Regards
Claus B.

 

[jaleel.k.mohammed]

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

Hi Claus,

Thank you very much. You are incredible!

Regards,

Jaleel