how to extract multiple rows of data based on a single row value?

Hello,
I hope my title can explain what aim to do.
I've been doing the work manually, using filters and pivots, but after being on leave for 2 months, I came back to a 36k lines.
I hope you guys can give me a pointer if excel can automate this for me.

The situation as follows:

The main list contains all billing details for all the items and medications charged on the patient.
I need to extract only data based on patient date of visit (ISSUE DATE - columns D) and only patients that was issued the item"CHEMOPREPARATION-1" (ITEM NAME - columns B)
The tricky part is I know that I can filter the needed patients (REGISTRATION NO) with the chemopreparation-1 line, but how to get the other items charged in the same date for the same patient as well?

And moreover, how to extract that data into a tabular form.

sorry for time it took you guys to read, but hope you get what i want.
I will attach what i do manually, hope you can help me as always.

Appreciate your work.

Please attach a sample workbook.

Are you following the instructions in the yellow banner at the top? If you do, it will work.

resiexfor. You would like to see list of items with ISSUE DATE the same as CHEMOPREPARATION-1 was and REGISTRATION NO , is't it?

It could be done by advanced filter but it will be very slow. Because you still use 2007 PowerQuery is not available for you and I see only two ways VBA and MSQuery.

Please Login or Register  to view this content.

Yes, That's exactly what i want, this file was created on work computer .. I have excel 2013 at home.

and wow.. you managed to summarize my whole post in one line.