Repeating Products for Multiple Locations

lipipe

New Member
Joined
Aug 13, 2011
Messages
40
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
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,884
1. What worksheet is the 12000 products listed on?
2. Is the the "master document" ?
3. What rows do the 12000 products occupy?
4. What columns contain the unique part number and description and Location field?
5. Where do you want the 16*12000 new entries to appear?
6. What kind of linked formulas exist now?
7. Should they/How should they change for the new entries?

Consider using Excel Jeanie (see link in my sig) to post relevant portions of your worksheets/formulas.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,704
Members
414,401
Latest member
grenona2020

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top