Hi Joel,
first of all thanks a lot for your time.
let me explain to you what i want to do.
there are 3 sheets
sheet1: (items occurs many times) total 7 columns
No item requiredQty store1 store2 store3 ETA
2 apple 6
5 orange 4
9 kiwi 5
7 guava 3
5 apple 7
sheet2
item occurs only one time)total 7 columns
item store1 store2 total qtysupplied balance No
orange 3 2 5
apple 5 8 13
guava 10 12 22
sheet3
item occurs only one time) total 6 columns
item ETA store3(total) qtysupplied balance No
guava
apple
kiwi
pineapple
what i have to do is take an item from the sheet1 and search for the item in
sheet2.
if the item is found, check against the required quantity and the quantity
available in column total of sheet2.
supply the required qty to sheet1, if the qty is not enought then go and
search in sheet3.
when we supply the quantity to sheet1 we should check from where we are
supplying the quantity from store1 or store2.
after supplying the reqd qty, if anything left then keep that balance qty in
Balance column.
in sheet2 from where we supply the qty, in that row in the column No, we
have to enter the No(first colm in sheet1) of the item to where we have
supplied.
in sheet3 if the matching is found, we have to chk with the total and along
with the qty we have to take ETA of the item and enter in sheet1.
Note: when the item occurs second time or nth time, it has to go check for
the qty in the column Balance.
and enter the qtysupplied, balance and No in the second row(we have to add a
row)
if you don't mind
please give me your email address so that i can send you the excel sheets
or you can drop a mail to me at
(e-mail address removed)
i have left with two more days to complete this project.
thank you very for your time
Ren