Good Morning! I have a list of 12,000 products. I need to create an item record for each of my 16 locations. The products are currently listed in excel with a unique part number and description and Location field. I need to list the products with the following location fields: 01,02,03,04,05,06,07,12,13,14,15,50,51,70,80,90
For example
100-100 1ST ITEM 01
100-110 2ND ITEM 01
then repeat with the next location:
100-100 1ST ITEM 02
100-110 2ND ITEM 02
I could fill int he location numbers, copy and paste 16 times but because I have formulas linked, I wanted to see if there was a script that I could ready that could do it after I copy and paste the values so I can continue to work on the master document and expand it as a last step. Thank you in advance!
Jack
For example
100-100 1ST ITEM 01
100-110 2ND ITEM 01
then repeat with the next location:
100-100 1ST ITEM 02
100-110 2ND ITEM 02
I could fill int he location numbers, copy and paste 16 times but because I have formulas linked, I wanted to see if there was a script that I could ready that could do it after I copy and paste the values so I can continue to work on the master document and expand it as a last step. Thank you in advance!
Jack