N
Nikhil
Hi...have a problem....
I have a product available across different cities. This
data is available in different sheets. For eg.sheet A will
have product & stock in city A, sheet 2 will have product
& stock in city B...
In the summary sheet, i have a product list and i would
like to have the cityname where max stock of the
particular product is available. Also in the adjoining
column, i would like to have the stock figure that is
present in that particular city.
Plz note however that while in all sheets and the summary
sheet, the product is listed in columnA, the row no. for a
particular product would differ in different sheets.
e.g Product X might be in cell A4 in sheet1 but might be
in cell A7 in some other sheet or just might not be there
(if stock is zero) for some city.
Plz help ASAP
Regards
Nikhil
I have a product available across different cities. This
data is available in different sheets. For eg.sheet A will
have product & stock in city A, sheet 2 will have product
& stock in city B...
In the summary sheet, i have a product list and i would
like to have the cityname where max stock of the
particular product is available. Also in the adjoining
column, i would like to have the stock figure that is
present in that particular city.
Plz note however that while in all sheets and the summary
sheet, the product is listed in columnA, the row no. for a
particular product would differ in different sheets.
e.g Product X might be in cell A4 in sheet1 but might be
in cell A7 in some other sheet or just might not be there
(if stock is zero) for some city.
Plz help ASAP
Regards
Nikhil