create multiple rows using a variable in a cell as source
 

Robert,

See my answer in the misc section.

You should only post in one section. Posting in multiple sections is a
no-no.

Regards,
Kevin


wrote in message
...
Is there a way, to create multiple rows using a variable
in a cell as source to indicate the number replicated
rows needed?

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 but need some guidance to get
started.

Thanks for any help!

Robert