R
Russ
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 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 section of the 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 mixe (non-grouped) non-consecutive products, I would like them grouped together in the an area elsewhere on the sheet.
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 section of the 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 mixe (non-grouped) non-consecutive products, I would like them grouped together in the an area elsewhere on the sheet.
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.