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

Report
Posts
1
Registration date
Thursday February 27, 2014
Status
Member
Last seen
February 27, 2014
-
 Sadat -
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!!!!

1 reply

Posts
2621
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 28, 2020
420
Hi Cunla,

The following link seems to be exactly what you are looking for:
https://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