find the matching and allocate the required quantity

[Ren]

hi i am using excel 2003,new to VBA
I have 3 sheets (pl see at the end)
Sheet1 “LIST†(n number of rows,keeps changing)
Sheet2 “slrsâ€
Sheet3 “fabâ€

Sheet1 “LISTâ€, column B…..take the item and find whether we have
the matching in “slrsâ€,
if there is a matching then take the corresponding value and place it
in "LIST" column D(store1) or E(store2)( based on the slrs-location ie
store1 or store2),check the quantity is sufficient enough to supply the
columnC ie Balance quantity,
If not goto “Fab†and search for the matching device,if u find the
matching take the value along with the DATE
If there is no matching in both sheets,then leave it empty
if qty is not enough write NA
In both the cases we have to take the corresponding PONUMBER and place
it in allocation column.
The quantity you supplied in quantity column,and the balance quantity left.
And repeat the process for all the devices.

The items will appear many no of times.

Note: some items have the matching more than one ie if u don’t find
SC14471A8 9M7
or the sufficient qty is not there then look for SC14471A8 TM7

the result should looks like this
sheet1(POLIST)
Number L50 reqd qty DIE WF FAB ETA
45594010 LMX4180G8 170092 170092
45600810 LMX4180G8 331068 169081
113703 20071224
48285 20080104
45613110 LMX4270C8 294954 3000
159942 20080101
90876 20080104
41136 20080119

sheet2(SLRS) (Grand total=Die+WF)
DEVICE Die Wf GrandTotal bal allocation qty
LMX4180G8 339173 339173 169081 45594010 170092
0 45600810 169081
LMX4270C8 3000 3000 0 45613110 3000


sheet3(FAB)
L50 ETA Total bal allocation qty
LMX4180G8 20071224 113703 0 45600810 113703
20080104 1279155 1230870 45600810 48285
LMX4270C8 20080101 159942 0 45613110 159942
20080104 90876 0 45613110 90876
20080119 272629 231493 45613110 41136