Create a macro to do the following:
1. we have an xlsx file.
2. column AH has data “Something”
3. column AJ is blank
4. Lookup “something” in list of 40 items, ( we will provide list)
5. find the one that correalates to “Something” ie: 50
6. replace AJ with 50
7. loop until all rows in AJ are full with the corresponding number.
DO NOT BID ON THIS UNLESS YOU CAN DO IT IN 1 DAY
RUSH JOB: NEED TOMMORROW!!!
