shortman_alan,

I think I understand your requirements.

For each "Asset Number", in workbook "Activity Listing with Activity Cat.xls"

find a match in in "actuivity number", in workbook "Schedules_2008.xls",

and copy the "Category" in workbook "Activity Listing with Activity Cat.xls", into a new column in workbook "Schedules_2008.xls"????


In workbook "Schedules_2008.xls", what column will be the new "Category" field?


Have a great day,
Stan