R
Rao Ratan Singh
Sir,
I have Three Worksheets of PaintingStock, JewelleryStock and TextileStock.
It have particular
ID No. of particular item.
I report daily to my boss that what is item number sold from the above
mentioned stock and
what was the cost price.
How i can track in one seperate sheet its actual cost price using ID No. of.
All Sheets have columns in this manner
A B C D
ID No. ITem Name Cost Price Sale price
and My Daily Sales report format is in this manner
A B C D
ID No. Name of Item Cost Price Sale Price
I want to track cost price in column C using a formula which u will be
suggest.
thank and regard
RRS
I have Three Worksheets of PaintingStock, JewelleryStock and TextileStock.
It have particular
ID No. of particular item.
I report daily to my boss that what is item number sold from the above
mentioned stock and
what was the cost price.
How i can track in one seperate sheet its actual cost price using ID No. of.
All Sheets have columns in this manner
A B C D
ID No. ITem Name Cost Price Sale price
and My Daily Sales report format is in this manner
A B C D
ID No. Name of Item Cost Price Sale Price
I want to track cost price in column C using a formula which u will be
suggest.
thank and regard
RRS