filter and copy

[stevekirk]

hi,

could you please look at the attached file and help me with the following

If i filter on typeA i want those results to go into another worksheet
if i filter on type b i want that information to go into the same cells on the other worksheet as typea went into

thanks for your help
steve

[VBA Noob]

Hi,

Here's some recorded VBA code that might work for you.
You need to add headers to data in Filter from Tab first.

Filter either Type A or Type B then press Alt + F8 then run the macro called filter. If you used the code a lot then add a macro button (see link)

The data pastes into Cell A12 down on the filter 2 sheet

http://articles.techrepublic.com.com...9-1060039.html

Please Login or Register  to view this content.

VBA Noob

[stevekirk]

hi,

thanks works great

steve

[VBA Noob]

Hi Steve,

Glad I could help.

If one Type has a longer list than the other you might need to record some code to clear contents in Filter 2 from A12 down before you copy the data

VBA Noob