Hi Singh,

by assuming while it seems the fiscal year starts around the mid calendar
year...

Col. B contains is the inventory table

? Col. A contains the Item ID....do you mean series ID ?
[then by assuming it is the ITEM ID] formulated to return the inventory
entry ID..

i suggest to use the same formula you have while preparing the inventory
item ID's per financial year per SHEET.

In sheet1 Year 1
the first item ID
say A2=200600001 : B2 = "your inventory"
then on A3 = if(B3="","",A2+1) :copy down to cells below
there shall be no blank row in between your records.

In sheet2 Year 2
the first item ID
say A2=200700001 : B2 = "your inventory"
then on A3 = if(B3="","",A2+1) :copy down to cells below
there shall be no blank row in between your records.

if you define the start date of fiscal year and have a column of reference
date on inventory record, maybe u can summariza all farther in a single
sheet..

regards

--
*****
birds of the same feather flock together..



"Rao Ratan Singh" wrote:

Hi there,
I m keeping inventory record in excel sheet using my Item ID like this -
200600001 and so on by entering formula==IF(B50,A4+1,""). Presently 258
items i have entered in this finacial year and las ID number is 200600258.

But is there any way that for whole financial year 2006-07 it works in this
manner 200600001 and son and as just as next financial 2007-08 comes and what
product inventory falls in this new year it automatically starts from
200700001 and so on.

I hope for best simple formula.