An excel macro is needed to run an automated task. A spreadsheet has data in it that is formatted like that show in the attached example file. Along each row there are Data cells, each of which is needed to fill out a separate row that is otherwise a clone of the initial row.
Example, a row that contains the following where each comma denotes a column (the relevant data is in capitals):
Fluffy bunny, pet collars, PINK, DIAMOND, CHROME, $12.96.
The macro should generate the following based on that
Fluffy bunny, pet collars, PINK, DIAMOND, CHROME, $12.96, PINK
Fluffy bunny, pet collars, PINK, DIAMOND, CHROME, $12.96, DIAMOND
Fluffy bunny, pet collars, PINK, DIAMOND, CHROME, $12.96, CHROME
The macro should be able to have its input & output cells defined. It should be able to deal with blank cells, where a blank cell does NOT generate a new row. The input data maybe 2 cells long or 200. Only the data used for the input should change when a row is generated, all the other information must be copied into the new rows.
There may be anything from 1,000 to 20,000 initial rows with unique input data. Please note that the initial row must NOT be left in place unchanged, it must be written to with the first Data or deleted so that with 3 initial Data entries there are 3 rows at the end, not 4 (the initial row & 3 newly generated) or it should be deleted when the macro finishes with that row & moves onto the next.
There is an example sheet attached to show you what it should look like. If you have any questions please ask & I will try to clarify any areas not understood.