Formula to copy rows a set number of times
Solved/Closed
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
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!!!!
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!!!!
Related:
- Formula to copy rows a set number of times
- Number to words in excel formula - Guide
- How to set whatsapp time - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Ms word number to words formula - Guide
- How to set auto redial on android - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Mar 3, 2014 at 11:27 AM
Mar 3, 2014 at 11:27 AM
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
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
Feb 11, 2016 at 03:30 AM