stair report pic.PNG
I have quantities listed in column D. In my worksheet, the quantities can go as high as like 16 I believe. I need a macro that will recognize the quantity and add quantity - 1 rows above or below, with the same data. For example, if the quantity is 4, it will add three additional rows, and add in the same data in all of those additional rows. After that, for all quantities, I need "1 of 2" "2 of 2" etc.... (based on the quantity) to populate in to the last blank column (column K). So if a quantity is 4, the original row, as well as the 3 added rows, should all have the same data, and column K will say 1 of 4, 2 of 4, 3 of 4, 4 of 4, consecutively in column K. It would help if a blank row remained in between each row, but it is not 100% necessary. I have made a similar post on reddit but it will not allow me to link to the post because I am too new to post links?
Bookmarks