Multiple autoFilter in same sheet

[sameerk0286]

hello there.

i am in dire need of some help. i have coded my filter in a module and i call it through the userform but my autofilter is not working well.

i have attached the coding and the autofilter fields i am using. please help me by helping me change it or something so that the filter will work.


thank you so much



regards


sam

Please Login or Register  to view this content.

[JBeaucaire]

To apply multiple filtering criteria on various columns with the AutoFilter in row1:

Please Login or Register  to view this content.

[sameerk0286]

To apply multiple filtering criteria on various columns with the AutoFilter in row1:

Please Login or Register  to view this content.

Why is it that only a few fields are copied to the other sheet by using this filter.

i want all the data to be copied after applying the filter. i use the coding

Please Login or Register  to view this content.

but i still am only able to copy 7 columns only.


please help

[JBeaucaire]

Your continued use of SELECT will frustrate your efforts. You need to address the data directly rather than selecting like a human. VBA has no need for selecting.

Since you've uploaded nothing I'm shooting blind here trying to help.

Please Login or Register  to view this content.

[sameerk0286]

Thank you guys so much. :D