|Subject:||create multiple rows using a variable in a cell as source|
|Date:||Thu, 23 Oct 2003|
Is there a way, to create multiple rows using a variable
in a cell as source to indicate the number replicated
In Excel, I have a name and address and another field to
indicate how many "rows" I need for that record. All the
quantity of replications will be different, that is to
say, I may need one of this one, but 4 of that one, and
10 of yet another. How can I use the quantity variable
to replicate the row in the worksheet?
Ideally, I want to use a source worksheet to create a new
worksheet or better, a workbook, of the replicated rows.
Any resources or ideas would be appreciated.
I am a beginning VB programmer so I am not adverse to
make a stab at coding this if need be, but need some
guidance to get started.
Thanks for any help!