Hi,

I have an Excel that track all the WIP in the system and trying to automate
placing the order# in the order cell to take away the time consuming manual
task.
I have a template sheet with No. column filled out. The raw data sheet with
raw data from the importing from Access that updated daily.

The intend is to look at the Model & Operation from the raw data sheet, then
start filling in Order# to the template sheet in the corresponding column I
to N based on the highest Oper order# first. H column is model number.
Criteria is to ignor (skip) any cell in column I to N with AS specified on
the template sheet. The sample data is below. There are 2 1300, 1500 and 1700
order# per No. Thanks

Template sheet1 before macro:
A H I J K L M N
NO MODEL 1300 1300 1500 1500 1700 1700
1000 100
1001 300 AS AS AS
1002 100 AS AS
1003 200
1004 300
1005 100

Raw data sheet2:
A B L O P
Order# Item Oper Ref Model
200201 123B1360-1107A 490 1300 200
200211 123B1360-1007A 490 1300 100
200260 123B1560-1107A 490 1500 200
200270 123B1360-1107A 490 1300 200
200213 123B1560-1007A 320 1500 100
200225 123B1760-1007A 320 1700 100
200200 123B1360-1203 310 1300 300
200224 123B1360-1203 200 1300 300
200265 123B1560-1007A 190 1500 100
200207 123B1760-1203 170 1700 300
200205 123B1560-1007A 150 1500 100
200217 123B1360-1203 150 1300 300
200256 123B1560-1007A 80 1500 100
200202 123B1760-1007A 30 1700 100
200206 123B1560-1207A 13 1500 300

Result after macro template sheet1:
A H I J K L M N
NO MODEL 1300 1300 1500 1500 1700 1700
1000 100 200211 200213 200265 200225 200202
1001 300 200200 AS AS AS 200207
1002 100 AS 200205 200256 AS
1003 200 200201 200270 200260
1004 300 200224 200217 200206
1005