Need Help Pulling list data into an excel spreadsheet

Attach a sample workbook so we can see more clearly what you are trying to achieve - the FAQ describes how to attach a file.

Pete

Thanks! I added it to my post

With reference to the cells in your workbook, can you explain again what input you want to have, and what you want to happen following that input?

Pete

Yes I would like it to look at C2 on the report tab and bring back all Po's from the PO tab Column B. The input would be starting in cell A7. So for example: the ID in C2 is currently 226908 so I would expect the following listed: 1800
1801
1802
1803

Thanks