Create new rows based on numbers in cells

[CaptainK]

Hello,

I am hoping to redesign the way I use Excel to keep inventory of things. Currently we have one row for every type of part, but I want to change it so that there is one row for every individual physical item. Example:

Current system:

Part	Made By	Quantity On Hand
Part A	Company 1	3
Part B	Company 1	1
Part C	Company 2	2

Desired:

Part	Made By	Quantity On Hand
Part A	Company 1
Part A	Company 1
Part A	Company 1
Part B	Company 1
Part C	Company 2
Part C	Company 2

So what the macro would need to do is insert n-1 rows beneath each initial row, where n is the current quantity on hand (stored in column C), and then copies down the part name and manufacturer. Is it possible to write a macro that is capable of doing that?

[rcm]

Please Login or Register  to view this content.