Automatic AutoFilter function for optional cells

Hi carmad...
Welcome to the forum...

My challenge is, that I have thousands of data rows, where it takes weeks to perform the AutoFilter function manually, to find invoice numbers that have not been paid, etc.

Attached does what you require...

However...
Seems there must be an easier way to get the result you are after...
I cannot imagine you wanting all the no's stored and then manually selecting and filtering...

Are you wanting to extract the data or just look at the data?
What suggests an unpaid invoice?

Explain in more detail and a simplistic solution can be offered...

Hi Sintek

Wau it was fast, thank you - and the result shows data filtered as I wanted it

But I can see what you mean, with an easier way compared to "selecting data"...

In my sample file, I had chosen to show the columns where the AutoFilter is used. But there are also other columns, such as due date, amount, and balance... I hope that's not a problem here, because I thought basically that the AutoFilter function works regardless of how many columns there are in the sheet.

In principle, I want to see data as it lies in the thousands (not extract), always sorted in date order, where the oldest date is first.

Now, not every invoice necessarily needs to be checked. So, when I select a particular invoice, it is usually the date I look at where there is doubt in relation to the amount and balance and whether the invoice has been paid.

Therefore, a "dropdown" list will probably be quite confusing, compared to how far down I look in data. So, there I had thought that I could "select" the cell / invoice number itself, in column B and "press" the "filter button" and thereby get the "automatic AutoFilter function"... Like "get" the "selected" value/cell – maybe?

I hope that explains the current heavy workflow, which I wish could be made simple with, selecting an arbitrary invoice number down in column B and with a click get the filter data.

Therefore, a "dropdown" list will probably be quite confusing, compared to how far down I look in data. So, there I had thought that I could "select" the cell / invoice number itself, in column B and "press" the "filter button" and thereby get the "automatic AutoFilter function".

So is this the ideal situation for you...

If so then this is all you need...Select Col B to filter Col 5

Please Login or Register  to view this content.

Please Login or Register  to view this content.

But you said...

selecting an arbitrary invoice number down in column B and with a click get the filter data.

If you want to select in Col E and Filter Col E then...

Please Login or Register  to view this content.

Glad to have helped...