Formula to copy rows a set number of times [Solved/Closed]

Posts
1
Registration date
Thursday February 27, 2014
Last seen
February 27, 2014
- - Latest reply:  Sadat - Feb 11, 2016 at 03:30 AM
Hello,
I have a delivery manifest that shows the amount of products coming in, descriptions etc. that we use to produce barcode labels. Unfortunately the barcode software we use means that we need to duplicate the information in rows for the amount of items we have- for example if we are due in 12 IPads we must replicate the rows 12 times- is there any way I can link the 'number due in' column to replicate the data for me?
Thanks in advance for your help

This problem was posted in 2013, but I do not know how to set up a macro... Is there some formula I can use instead???
Please help, i've searched the internet for two days and I need to resolve this quickly.
Thank you!!!!
See more 

1 reply

Posts
2448
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 14, 2019
407
0
Thank you
Hi Cunla,

The following link seems to be exactly what you are looking for:
http://ccm.net/faq/7546-excel-repeat-rows-a-specified-number-of-times

PS. formula's can't copy/paste.

Best regards,
Trowa
Thanks so much