Intersect Function - Copy Data to other worksheets

[rka81]

I am currently having an issue with a piece of code that uses the Intersect function.

I have a sheet of data (called Data) and I wish to move columns of data within that sheet (Batch_Name_Col and Country_Code_Col) that meet certain criteria into a corresponding worksheet. Eg all the items with a Country Code of "CN" will move to the "CN"
worksheet.


Now the below works but I now need to "move" more than just two columns (poss. up to 10) and I just cannot seem to work out how i should amend this code and would really appreciate any assistance/pointers.

Please Login or Register  to view this content.

thanks again in advance - i am relly struggling with this one.

[Leith Ross]

Hello rka81,

If I understand you correctly, this should do what you want...

Please Login or Register  to view this content.

[rka81]

Hello rka81,

If I understand you correctly, this should do what you want...

Please Login or Register  to view this content.

Hi, Thanks for the response.

It's kind of what i need. In short - I need to copy say 10 columns of data for each row that has a specific "COUNTRY CODES" - so for every row that contains "CN" in the Country Code column I want to copy all that entire row to the "CN" sheet. I was trying to use my code to filter down per Country and copy the data per column - but couldnt work out how to copy more than two columns with the Intesect function without getting errors.

Sorry i'm not sure if this is explained well enough

[Leith Ross]

Hello rka81,

I think it would be best to post your workbook. If you are using Excel 2007, please post a copy in Excel 2003 format. I and many others don't have 2007. Be sure to remove or change any information that is either proprietary or sensitive in nature before you post your workbook.