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 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]