Copy Rows Based On Cell Value

  • Sorry to bother you all, but I have a somewhat large spreadsheet that I am working on manually, and I'm sure it could be done much more easily if automated.


    I have a list of items with a quantity in the final column. I need the rows to be copied the same number of times as the quantity displayed so that instead of having 1 row with a quantity of 5, it copies this row a further 4 times so that there are 5 rows.


    Can any shed any light on how this can be achieved other than manually as is currently the case?


    I've attached an extract so that you can see what I am working with.


    Column H holds the quantity (obviously) and ideally should be reset to 1 when the item is copied the relevant number of times.


    Thanks for your help.

  • Re: Copy Rows Based On Cell Value


    Hi ya and Welcome :)


    Never a bother to ask a question here...


    Try this code...it will create the required list on a second sheet

    D ;)


    :sailboat: [SIZE=1]Better a bad day on the water than a good day in the office[/SIZE]