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.