Find all item codes for all items under one category
 

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

Find all item codes for all items under one category
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Kevin K" wrote in message
...
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

Find all item codes for all items under one category
 

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

Find all item codes for all items under one category
 

BTW..., If you have to go through that procedure many times - consider
Recording a Macro.
The Macro can, easily, be converted into an WorkSheet_Change Event-Macro
which will be "fired" upon each and every change of the criteria [cell D1]
Micky



"מיכאל (מיקי) אבידן" wrote:

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