vba, advancedfilter macro doesn't work for all the data

Hi

I'm using this macro to filter my data but it only filters the first 6 rows.

Please Login or Register  to view this content.

This code copies selected things that user wants to filter to Criteria-table

Please Login or Register  to view this content.

Is there another way to select the data (that will populate over time) instead of range().currentregion?
I'd appreciate it if anyone could help with this

Hi there,

Assuming your data for filtering begin in column A, over how many columns do your data extend?

Which column contains data which indicate the end (last row) of the data to be filtered?

Regards,

Greg M

Originally Posted by Greg M

Hi there,

Assuming your data for filtering begin in column A, over how many columns do your data extend?

Which column contains data which indicate the end (last row) of the data to be filtered?

Regards,

Greg M

my data is in a table from A to K and the number of the rows populates over time. right now I put a few examples and it has 10 rows.

Hi there,

If the last filled cell in column A defines the last row of your data set to be filtered, see if the following version of your "FilterMe" routine does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Originally Posted by Greg M

Hi there,

If the last filled cell in column A defines the last row of your data set to be filtered, see if the following version of your "FilterMe" routine does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Thank you very much

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M