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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create multiple rows using a variable in a cell as source 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Assign Selection to a Variable 2
How to create a bubble chart with more than 2 variables 0
Using the INDIRECT function across multiple worksheets 1
Using a variable as an argument 3
copy multiple rows 9
Copying cells from one worksheet to another, within the same workbook 7

Back
Top