Search Invoice No quickly and highlight

[majidsiddique]

Hi all,
i have a problem in search invoice no by filter quickly. in this i have to search sheet1 all invoices from 18-19-DATA sheet. can any body tell me how quickly i can do it? using filter, how i enter all invoices or search quickly and highlight.
if it is possible to search and only desired invoices and hide all other invoices.
Thanks.

[Richard Buttrey]

Personally I'd use a Pivot table with a Slicer for selecting the Inv. No.

See attached

[majidsiddique]

hi richard,
in this file, i want copy all search invoices at once then paste another file. slicer will be searched one by one. do you have any short cut?

[Richard Buttrey]

You can multiselect with the slicer.

Otherwise use an Advanced Data Filter and a criteria range.