Macro for multiple Criteria

Hello,

In the attached file I need a macro that do the following process if possible:

Look at Column A and if this column is equal to USS, then look at column D and if the pay level is equal to �R01�, change the total on column E to 15.00. However, if Column A still USS but the pay level is not R01 (or any levels as mentioned below) then change to 10.
Then the problem is that every ��R� level will change the amount:

R01 =15
R02=17
R03=24
R04=32
R05=33
R06=35

Also, I was wondering if will be a good idea to filter column A to anything with USS first? I have over 15,000 records. So not sure if the macro will become slow if is looking at each row.

Any help on this will be greatly appreciate it.

Thank you.

Try

Please Login or Register  to view this content.

This is based on info supplied above...

Please Login or Register  to view this content.