Macro to compare columns in 2 worksheets and paste to 3rd worksheet

[jsticca]

Hello,

I've been trying to come up with a macro to suit my need but haven't been able to figure it out. This is what I am trying to do:

1. I can create a spreadsheet from a database that lists all action items from various reviews. This spreadsheet cannot be edited but can be refreshed at any point in time to update the action item status.

2. I created a new blank worksheet in this workbook and filled in various review numbers that I care about [Column A].

3. The original spreadsheet with action items contains the action item numbers in one column which contain the review number within them [Column B]. So for review number AI-R5-2010-584659 the original spreadsheet would have all action items listed by AI-R5-2010-584659-01, AI-R5-2010-584659-02, etc.

4. I want to create a macro that compares the review number portion of the action item number in Column B of "Sheet1" to the review number in "Sheet2" and then copy all matching rows from "Sheet1" to a new worksheet [Sheet 3].

5. Additionally, I would like to copy the header row in Sheet1 to Sheet3 as well.

If I can automate this process it will be of great help for the future.

Hopefully this all makes sense and thanks for the help!

[rylo]

Hi

See how this goes.

Please Login or Register  to view this content.

rylo

[jsticca]

Awesome! This worked just as expected.

I added a few things to the code to make it a little more functional. The only other thing I would like to do is make all of the headers drop down lists in the "Project Action Items" worksheet. Any ideas?

Here is the code I have:

Please Login or Register  to view this content.

Thanks!

[rylo]

Hi

How about an autofilter.

Please Login or Register  to view this content.

rylo