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

cunla 1 Posts Thursday February 27, 2014Registration date February 27, 2014 Last seen - Feb 27, 2014 at 11:15 PM - 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 

2 replies

TrowaD 2391 Posts Sunday September 12, 2010Registration dateModeratorStatus July 12, 2018 Last seen - Mar 3, 2014 at 11:27 AM
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