Excel VB to copy and paste a number of rows based upon a cell number
Posted on 2009-04-30
I have a sheet called Production label that pulls information from other cells on other sheets. I need to copy and paste the information in these cells onto another sheet multiple times based on a value in a cell. Production label sheet has Columns setup starting at A1 and going to J1 titled as Company, Job, Mark, Finish, Height, Width, Model, Batch, Production, number. Each row pulls the information from other sheets.
I need a script that will copy the entire row, except the number cell, to another sheet multiple times. The multiple being the value in the number cell.
I know nothing about VB.
Thanks in advance.