create multiple rows using a variable in a cell as source

Giganews Newsgroups
Subject: create multiple rows using a variable in a cell as source
Posted by:  anonymo…@discussions.microsoft.com
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
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 if need be, but need some
guidance to get started.

Thanks for any help!

Robert

Replies