Search and Some from different sheets in Same workbook

[irfanhashim18]

Dear All,

Hoping for your help in this.

i am learn Excell basic. but my job expect me to do advance excell.

I am Cost Accountant in a Catering Company and i have to prepare a Daily consumption of material on 3 times (BREAKFAST LUNCH DINNER) we have item codes
list... i placed vlookup formula in description and UOM for easy work.. like put code in Item code Column so description and UOM comes out dont have to right again and again.

Example

Breakfast Lunch DINNER

ITemCOde Description UOM Qty Item Code description UOM QTY Item Code description UOM QTY
13001 White Rice KG 100 12008 break pckt 350 14001 oranges piece 700
12008 break pckt 150 14001 oranges piece 700 12008 break pckt 150
13001 White Rice KG 200


this is done:


i want
at the end the will be a sheet (daily activity)
which search the product used in Breakfast Lunch Dinner Sheet and some the match like

DAily Activity

Item Code description UOM QTY
13001 White Rice KG 300
12008 break pckt 650
14001 oranges piece 1400
like this.. so this will be transfer to main stock card..


BR
IRFAN

[igoodable]

This solution is a bit crude, but i hope it works for you...

I have to combine a pivot table to get the unique values your items used. You'll need to go to DATA/Refresh all to update the table.

[irfanhashim18]

This solution is a bit crude, but i hope it works for you...

I have to combine a pivot table to get the unique values your items used. You'll need to go to DATA/Refresh all to update the table.

thanks for this...it exactly what i want... thankssss again

another Task that will reduce my Data entry up to 30% ... is this Work sheet is Done... i have other Work sheet Called Stock Card where there will be data of in Out from Store for one project is Enter .. Out will be data from Daily Activity sheet You Design and Stock In will be GRN in the Same workbook you worked..

that has 30days columns...
I want that Two Workbook Match the date........ and Stock Card Work Book enter data from Example 4. workbook by matching Date and Item Code... without vanishing the previous Dates Data..


it it Possible??

thanks Again for this ...