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

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
:

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

On Monday, February 2, 2015 at 10:41:13 AM UTC+5:30, wrote:
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