create multiple rows using a variable in a cell as source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top