Writing a Macro that looks to a value in a cell and returns a list of items that correspond to that value?

Please describe how you want the macro to work.

Sorry for not being clear, was hoping the Marco would return the lists of item numbers into E6 on tab one. Thank you!

You can achieve this without VBA or formulas. You can use a Pivot Table.

See attached. This uses the department as a Page Filter and then it shows the list of item numbers for that department.

If you were to change the data list to an excel Table rather than a standard list the Pivot would adjust automatically for the range of data expanding (or shrinking).

Thanks
Rob
Excel-Help-11.xlsx

Thanks for the points. Oh wait, everybody but me received them.

Hi Rob,

I have a the remains of a pie here, you're welcome to have.... here, catch!

Oops, sorry.  I'm sure it will come out.

Alan.