Need excel copy a row and automatically insert new rows based on a cell contents

P

paulmm

How do I make excel copy a row and then automatically insert new row
that are copies of that row based on a number in one of the cells in th
original row.

(ie; if the original row (Row 1),has purchase info about 10 ten pc's
(Quantity in Column B), I need to generate ten rows with the detail
from Row 1)
 

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

Automatically insert new rows 2
make excel copy a row and automatically insert new rows 2
insert rows automatically 7
VB to insert duplicate rows based on value in other row 1
Excel macro to copy rows in one sheet and insert into another sheet 5
Macro to Run Functions and VBA code??? 0
How do I insert a row or rows between each row of text and copy the row above? 0
VBA - Insert row, copy contents of original row except for contents of column A 3

Top