Data transfer between two sheets based on condition

**shortman_alan** · 11-26-2008, 04:41 PM

hey,
i have been having the same issue with a spreadsheet of my own!
how did you solve this? vlookup? as im yet to get that to work?

http://www.excelforum.com/excel-prog...condition.html

**stanleydgromjr** · 11-26-2008, 09:45 PM

shortman_alan,

Please post your workbook - scroll down to "Manage Attachments".

Have a great day,
Stan

**shortman_alan** · 11-27-2008, 08:26 AM

sorry when i day sheets i ment workbooks. is it any similar?

i have departments in both books that are in common although one book has the departments activities and their categories and book 2 has the departments actives and their frequency. i would like to match these up and copy the activity's category into book2.

cheers!

**stanleydgromjr** · 11-27-2008, 11:29 AM

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** · 11-27-2008, 04:33 PM

thats it!.

it would be great if the catagory could be inserted between A and C?
but if not J will be fine.

cheers!

**stanleydgromjr** · 11-28-2008, 01:15 AM

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