Possible to create a macro which filters based on multiple selected cells in a column?

[Elijah]

Hi all,

Googling around I found this great macro which really speeds up on filtering my tables. Basically, I can select a cell value and the macro auto-filters based on this value. Not only that, but I can select multiple cells across multiple columns as long as they're on the same row and filter based on this. Great.

But, I often find myself narrowed down with a column of key data where I want to further drill down and isolate selected values. For example like this:

FilterSelectedCells.png

I currently do this with the cumbersome process of crossing out these values manually.

Would it be possible to have this done automatically with a macro? Can anyone assist me doing so?

Here's the macro I currently use described above:

Please Login or Register  to view this content.

Thanks in advance for all help!

Best,

Elijah

[Fluff13]

As long as all the selections are in the same column try

Please Login or Register  to view this content.

[Elijah]

Hi, Fluff13,

Seems to work great for that specific purpose.

If I'm not mistaken or did something wrong, this one does not retain the functionality of the original macro (filtering across multiple columns).

Is it possible to combine the two?

Although it would be nice, I don't need to filter multiple selections in one column across multiple columns.

But it would be nice if I could do both separately. If that made sense...

If not, I can simply have two buttons. One for each macro function.

Thanks in advance.

Elijah

[Fluff13]

It should be possible to allow multiple values in multiple columns, but I don't have time right now.
If nobody offers a solution I'll have a look at it tomorrow if I get time.

Thanks for the Rep

[Elijah]

Thanks a lot, Fluff. There's no rush and what I have now (two macros separately) does the job. Would just be nice to combine it all in one macro.

Best regards.

[Elijah]

Hi, Fluff,

If you have time and interest, I would greatly appreciate a macro that could provide the functionality of my original macro and the functionality of the one you created. I can pay you for it if that's an option.

Thanks in advance.

Elijah

[alansidman]

If you wish to make a payment for services on this forum, then you need to post in the commercial services sub-forum. This is an all volunteer forum and payment for services is only available through that system. If this is a direction you wish to go, please advise one of the moderators to close this thread and you can open a new one in the commercial services sub forum.

[Fluff13]

@Elijah
I've had another look at this & it's going to be very complicated (for me at least).
Therefore I'm not going to have sufficient time to spend on providing a solution.

[Elijah]

If you wish to make a payment for services on this forum, then you need to post in the commercial services sub-forum. This is an all volunteer forum and payment for services is only available through that system. If this is a direction you wish to go, please advise one of the moderators to close this thread and you can open a new one in the commercial services sub forum.

Understood. I'll think on it, Alan. Thanks.

[Elijah]

@Elijah
I've had another look at this & it's going to be very complicated (for me at least).
Therefore I'm not going to have sufficient time to spend on providing a solution.

Hi, Fluff,

No worries. Thanks for taking a look though.

Just to be clear in case there was any confusion.

I don't need the macro to be able to perform the two types of sort simultaneously at once. Just being able to do each separately once at a time, but with only one macro/button on my screens.

Best regards.

Elijah

[Elijah]

EDIT: This particular questions was cross-posted at mrexcel.

Hi, everyone,

Can this code be modified to filter for greater than/less than a selected cell value?

Currently, it returns values equal to cells selected.

I find myself often wanting to filter values >= or <= than a cell value. Can this be done in VBA? I'm thinking one macro for each condition then.

I tried modifying this code, but didn't arrive at a solution...

Please Login or Register  to view this content.

[Elijah]

Any ideas?

Or maybe a new macro from scratch...?

I found a macro online which could filter based on bigger than a predefined number, i.e., > 100. But for my purposes, it would have to refer to a selected cell value...

Thanks in advance.

Elijah

[Elijah]

I'm at a loss here.

Seems like I can be able to create a macro showing >= a predefined value, but not according to a selected cell value.

[AliGW]

You have marked the thread as solved - is it?

[Elijah]

You have marked the thread as solved - is it?

Hi, AliGW,

Merry Christmas!

The initial question was solved (filtering equal values).

But my follow up question (filtering equal or greater) is not.

I didn't want to create a new thread for it since I imagined it to be very related. I could take of the "Solved" for a while.

Elijah

[jeffreybrown]

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #3 about cross-posting and adjust accordingly...
• Also see, A message to forum cross posters

[Elijah]

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #3 about cross-posting and adjust accordingly...
• Also see, A message to forum cross posters

Hi, Jeffrey,

Thanks for letting me know. I was not aware that this was an issue and only cross-posted after this topic had been unanswered for a while...

I made a notice about this on post #11 in this thread and apologize for violating forum etiquette. I'm very grateful for all help received here, so no disrespect intended on my end.

Best regards,

Elijah

PS: I can delete the other thread or these last posts if that's the appropriate thing to do.