How to Filter fields

[EC37]

need some additional help to a thread I had posted yesterday, but different subject this time around.

Yesterday, I needed help copying information from one workbook to another- which was solved.
Now, I have a 3rd workbook. I first need to filter 2 fields before i can copy the information to the other workbook. I'm having trouble doing so. Here is what my code looks like right now, but the most I can get it to do is to turn on the filters, but I can't select the 2 columns I need to filter by and provide it the criteria.

Please Login or Register  to view this content.

Row 4 is the Header, would that be the issue?

The second column I need Filtered is column V, but for that filter, I need it to exclude "New York". Is there a way to tell it 'does not equal' as opposed to providing it all of the acceptable cities and purposely leaving out New York?

Thanks so much!
E

[JOHN H. DAVIS]

For Column V.

Please Login or Register  to view this content.

[EC37]

Could I essentially do the same for my need to filter by Boston in Column M?

Please Login or Register  to view this content.

[EC37]

Also, this doesn't work. I inserted the above, exactly as written, and it tries to filter Column A to not equal "New York". Which, isn't even an option for Column A. Since I'm not pointing to it, I'm not sure why it's trying to go there.

[JOHN H. DAVIS]

Could I essentially do the same for my need to filter by Boston in Column M?

Please Login or Register  to view this content.

Yes, but in that case you don't need the equal "=" sign.

Can you provide a copy of a sample file in which the code doesn't work? If you use the code provided with the range provided as well, I don't know why it would try to filter on Column "A"??

[EC37]

Err. Unfortunately it's all confidential data. Boston and New York are actually irrelevant, just used to figure out how to write the code

it would take some time to rebuild as dummy data. But, after you provided the info on how to write the filters, this is how the code looks?

Please Login or Register  to view this content.

I can't figure out why it would point to Column A.
The other weird thing, is by inserting those 2 lines, it removes the AutoFilter I set for A4:BZ4- and instead only has filters on M & V.

If I remove the line to filter on "Boston", it instead points to Column A. If I keep the code as is, above, it tries to filter Column M to not equal New York.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[EC37]

Successsss. You are the best! Thank you!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please compy with Forum rules and mark this thread as SOLVED. See Rules link for guidance.

http://www.excelforum.com/forum-rule...rum-rules.html