require a macro to insert rows based on a value

[_bob_]

Hi, I have a list of data - basically a production plan that I need to insert rows based on a cell value

I start with a list of orders, each order having a number of required operations. From this, I want to create a new set of data that has the number of rows for each order based on the number of operations per order.
see the attached file - columns A to C are the original data, columns E to H are what I need to get.

thanks!

[Excelnoub]

Add this for starters to your VBE Sheet1

Please Login or Register  to view this content.

[Excelnoub]

New code above let me know if it works for you

[_bob_]

Hi Excelnoub, thanks for the quick reply. sorry, I'm new to macros...How do i set this up to run this macro manually? thanks

[Excelnoub]

I will send you a workbook let me know if this is ok...

I will also add something to restrict your column C to only numbers.

[Excelnoub]

Order.xlsm

Try this... add a number in Cell C2... Try adding 2 or 3... Then try to add a letter.

[_bob_]

thanks again, look like it functions ok, but I will start with a complete list first (using a lookup on the number of operations), then will need to have the macro run manually and create the expanded range of data either adjacent to the original data range, or preferrably on a new sheet if that's possible...

[_bob_]

Hi Excelnoub, sorry this isn't quite what I'm looking for, I need the new list to be generated on a new sheet, and the macro to be run manually, not as the data is entered. thanks