PASTE a ROW of data with MULTIPLE COLUMNS and FILTER it from your existing excel database sheet?

[jetturk]

Let's say I have a long list of database on one sheet. In another sheet, I’d like to have an area that I can PASTE the search query which is a single row of data with multiple columns.. Something Like "number number text number text " 5 columns can be pasted to an area and as I pasted , it should bring the data from the database sheet. Please note, I am not looking for a fixed data filter here, each time I should be able to paste and delete( clear) this row of data, so that I can filter for new row of data as I needed. I havent seen any example on the internet. If someone can help me on this, will be much appreciated. Thank you

 

[NoSparks]

Sounds like Excel Advanced Filter is what you should be searching for.

 

[jetturk]

Thank you, but you cannot paste multiple columns on that. One by one time consuming, hence the need of the paste of multiple columns on a single filter row.

 

[NoSparks]

You are the only one who knows what the relationship is between what's being pasted and your database so I guess you're right.

 

[jetturk]

Here is an example. I have the data sheet. Instead of entering the values one by one, I'd like to copy 3 columns of data row, and paste it somewhere to filter. Hope this makes sense.

 

[NoSparks]

If row 1 on your other sheet was a copy of the header row of your database could you not paste to row 2 starting at the appropriate column in order to establish the criteria range for an Advanced Filter ?