This is an excellent opportunity to exercise a classic "Advanced Filter"
procedure from an adjacent Sheet.Assuming
* Assuming the data source table is in range A1:B31 on Sheet1 - you MUST
start the procedure from the Target Sheet (Sheet2).
* Activate Sheet2 and type the EXACT source table headers in A1:B1 in Sheet2.
* In D1:D2 enter The Cat. Header & criteria.
* Start the Advance Filter while Sheet2 is the ACTIVE sheet.
* Take care of 3 arguments, in the in the auto filter window, presented in
my picture.
* Mark the Radio Button "copy to anotherplace"
*** The titles are in Hebrew but you will be able to Identify them' easily'
in your Interface language ***
* Upon hitting OK only the appropriate records, from the source table will
be shown in col. A+B on Sheet2.
I do hope this fulfill your request.
http://img705.imageshack.us/img705/2219/nonameg.png
Micky


"Kevin K" wrote:

I have a list of thousands of UPCs with the category name in adjacent cells.
I need to build a formula to automatically populate a list of UPCs based on
the category selected in another worksheet in the workbook. The category
selection is already automatically selected from data that is imported in
another worksheet in the workbook.

This seems like it should be very simple, but I can't find anything online
that provides a simple way to do it. I only find manual ways to do it.

Thanks for any help out!
Kevin K