I am trying to make a Search sheet that searches a Master list and returns a list of items that person has.
Ideally this would return the quantity in the column combined with the header row.
Ref attached. As you can seen when the basket number is entered, it populates the name of the basket holder; I've got the filtering figured out, its just the rest. I want it would fill down the rows rather than across columns (I was able to do that), as I would intend this to be printable on a regular portrait orientation. The original workbook has 33 "fruit" choices so it could get unwieldy
I have tried to cobble together a few things I have found in search but the combinations don't work. Maybe its not possible in which case I'll figure something else out.
Thanks for any help.
Bookmarks