G
Guest
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.
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.