Repost - Referencing values of a record entry, elsewhere!

I have an application that is used the track products by type. All related data to the pruduct is entered taking up one row and up to between 20 to 30 columns. The products are Column C and as follows: Horn, Switch, Resistor, Navigation, Headlights and so forth.

What I want to accomplish is whenever a record in entered for any of the above mentioned products to copy the entire record into another hidden section of the same spreadsheet (by reference to the product type entered) reserved for that product type. Sort of a grouping by product if you will. Since the method of record entry may be a mix (non-grouped) non-consecutive products, I would like them grouped together in the an area elsewhere on the sheet.

Example: If a record for the product "Horn" is entered retpeat the entry as it is created in a hidden section of the spreadsheet, but, limit the entry by product to a specific section only

Is this possible? I have a sample working some what I asking for, but, the record are placed according to record count position as entered.

"Russ" wrote in message
...
I have an application that is used the track products by type. All related
data to the pruduct is entered taking up one row and up to between 20 to 30
columns. The products are Column C and as follows: Horn, Switch, Resistor,
Navigation, Headlights and so forth.

What I want to accomplish is whenever a record in entered for any of the
above mentioned products to copy the entire record into another hidden
section of the same spreadsheet (by reference to the product type entered)
reserved for that product type. Sort of a grouping by product if you will.
Since the method of record entry may be a mix (non-grouped) non-consecutive
products, I would like them grouped together in the an area elsewhere on the
sheet.

Example: If a record for the product "Horn" is entered retpeat the entry
as it is created in a hidden section of the spreadsheet, but, limit the
entry by product to a specific section only

Is this possible? I have a sample working some what I asking for, but, the
record are placed according to record count position as entered.


This would require a macro (rather than worksheet function), so I suggest
you try posting in the Excel programming newsgroup.