Continuous Invoice Nos.

  • Thread starter Thread starter jaleel.k.mohammed
  • Start date Start date
J

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,
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
Click to expand...

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
 
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?
Click to expand...

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.
 
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
Click to expand...

Hi Claus,

Thank you very much. You are incredible!

Regards,

Jaleel
 
Back
Top