Hello Leela,
Automating the AutoFilter would be a good way of doing this task but seeing that your data set is not overly large, the ColumnDifferences method should do the task efficiently for you using an event code, placed in the Sheet1 module:-
This code will also transfer the headings over for you and Sheet 2 is cleared prior to any data transfer (I'm assuming that you want to keep the data in Sheet1).
To implement this code:-
- Right click on the Sheet1 tab.
- Select "View Code" from the menu that appears.
- In the big white code field that then appears, paste the above code.
I hope that this helps.
Cheerio,
vcoolio.
P.S. Sorry Leela. I meant to add a little more info for you. Basically, when you make a selection from the drop down list, the event code will automatically trigger and transfer all rows of data of the Counties not equal to the selection. No button is required.
Bookmarks