Actively copy row if column criteria met

**quanno** · 01-30-2012, 11:03 AM

I've searched and found plenty of threads regarding this, but I have not been able to adapt their solutions to my situation. This is mainly due to my lack of understanding.

I have a master roster on Sheet1 and wish to have a portion of each row copied to one of 4 additional sheets depending on the content of a certain column in Sheet1.

Sheet1 has columns A-Z, and in column F is an identifier for each person (A, B, C or H)

I want to copy columns A-N from Sheet1 to the respective sheet if the value matches. (ex. A copies to Sheet2, B to Sheet3, C to Sheet4, H to Sheet5)

I need this to be active in the sense that if I modify the value of Column F for a certain person in Sheet1, it moves the information in Columns A-N to the respective sheet.

What is the most effective way to do this?

**sweedey** · 01-30-2012, 05:21 PM

can you post a sample spreadsheet? I think that would help to better understand!

**Simon Lloyd** · 02-01-2012, 11:52 AM

You state "Copy" then finally you state "Move" which do you want to do?, also this cannot be done witha worksheet function it can only be done with VBA!