Data transfer between two sheets based on condition

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

shortman_alan,

In the workbook "Schedule_2008", sheet "List PM Activities":

column A title = "Dept"
column B title = "activity number"
column C, inserted new title = "Category"
column D title = "Frequancy In Days"

Is this OK with you?


Have a great day,
Stan

shortman_alan,

Attached are your two workbooks zipped, "Activity Listing with Activity Cat.xls", and a new copy of the other workbook "Schedules_2008.xls".

In workbook "Schedules_2008.xls", sheet "List PM Activities", I inserted a new column C "Category".

Both workbooks must be open.

The next formula goes into "Schedules_2008.xls", sheet "List PM Activities", cell C2. Remove the leading ' character, and then copy the formula down to the end of the data.

'=INDEX('[Activity Listing with Activity Cat.xls]Asset Activity Listing'!$B$1:$B$5000,MATCH($B2,'[Activity Listing with Activity Cat.xls]Asset Activity Listing'!$D$1:$D$5000,0))

Then, to change to values, highlight all the cells in column C, click on Edit, Copy, Edit, PasteSpecial, Values.


Have a great day,
Stan