Filtering Table for Multiple Names

Question

Hello,

I have written an excel workbook with about 300 rows and 6 columns. The rows are specific to an individual, for example row one column A has the persons name, column B has their number, column C has their order number, etc. I wrote a code that pulls the individual's information into a word template and sends an email. What I would like to do now is filter my table by multiple names. I've tried just regular filtering by name but once I choose one name and then choose another it resets the filter. I've tried advanced filtering, but that has not worked either. Does anyone have any suggestions?

Thanks

Answer 1

Hi,

I'm Anna, an independent advisor trying to help.

I found this link that might be able to answer your query: https://support.office.com/en-gb/article/filter...

For complex criteria in filtering data in excel, you may refer to this link: https://support.office.com/en-us/article/filter...

I hope this helps you.

Best Regards,
Anna