Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking values from different sheets
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking values from different sheets
Rao
Have a look at Data, Consolidate Peter "Rao Ratan Singh" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking values from different sheets
Dear Billy,
Thanks for response. I want to clear you more that i want to determine value after matching two criteria that is ID No. and Name of Item in Daily Report. Someone has suggested me this formula but how to use in which cell. =SUMIF(INDIRECT(IF(A1=1,"Sheet1",IF(A1=2,"sheet2", "sheet3"))&"!a:a"), B1,INDIRECT(IF(A1=1,"Sheet1",IF(A1=2,"sheet2","she et3"))&"!C:C")) Please clear me A1 for what an which range? a:a for which range My Daily Report Format is - A B C D ID No. Name of Item Cost Price Sale Price 001 Paintings 002 Silver 003 Textile 001 Silver 002 Paintings I as you know that in every sheet ID No. starts from 001. So ID No. 001 may be of Painting and may be of Silver or Textile. I want to determine Cost price from three of sheets. Sheets had renamed that is "Paintings", "Silver", and "Textiles". I hope now it is clear to understand my problem. "Billy Liddel" wrote: Rao Have a look at Data, Consolidate Peter "Rao Ratan Singh" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Ranges using non-contiguous cells and dependent on a cell value | Excel Worksheet Functions | |||
Need to condense my formula summing many values over many sheets | Excel Worksheet Functions | |||
Looping between sheets picking up values on the way | Excel Worksheet Functions | |||
exchanging values amoung sheets | Excel Worksheet Functions | |||
add values using vlookup over multi sheets | Excel Discussion (Misc queries) |