Formula to copy rows a set number of times

cunla Posts 1 Registration date Thursday February 27, 2014 Status Member Last seen February 27, 2014 - Feb 27, 2014 at 11:15 PM
 Sadat - Feb 11, 2016 at 03:30 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 3, 2014 at 11:27 AM
Hi Cunla,

The following link seems to be exactly what you are looking for:

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

Best regards,
Thanks so much