I am trying to write a macro that will take the Catalog ID Number and tell me what Location the product is in. I want to have one ID number and then list the locations next to it seperated by semicolons.
Here is an example.
Location Catalog Item ID
STORERM 009897
STORERM 013070
STORERM 014057
STORERM 016493
STORERM 016568
STORERM 016926
STORERM 018570
STORERM 018953
STORERM 018996
STORERM 019046
STORERM 019062
STORERM 021476
STORERM 022224
STORERM 027025
STORERM 027261
STORERM 032920
STORERM 033084
STORERM 038679
STORERM 041796
STORERM 047880
STORERM 047884
STORERM 047889
STORERM 047895
STORERM 048048
STORERM 048049
STORERM 048058
STORERM 048062
STORERM 049451
STORERM 063798
STORERM 070408
STORERM 070440
STORERM 070564
STORERM 070599
STORERM 071021
STORERM 071048
STORERM 071196
STORERM 071242
STORERM 071390
STORERM 075426
STORERM 075620
STORERM 083369
STORERM 084285
STORERM 085168
STORERM 090389
STORERM 092839
STORERM 092840
STORERM 092841
STORERM 092842
STORERM 093126
STORERM 093127
STORERM 093166
STORERM 093178
STORERM 093180
STORERM 102285
STORERM 116378
STORERM 116379
RM01 125781
RM01 125781
RM01 125781
RM01 125781
STORERM 125781
STORERM 129866
STORERM 130637
STORERM 130752
STORERM 139791
STORERM 143893
STORERM 145793
STORERM 146269
STORERM 147019
STORERM 153427
STORERM 156908
STORERM 157418
STORERM 157442
STORERM 157450
STORERM 157536
STORERM 157541
STORERM 157590
STORERM 161775
STORERM 162848
STORERM 167212
STORERM 167213
STORERM 167449
STORERM 167955
AS01 169535
AS01 169535
AS01 169535
HS01 169535
RM01 169535
STORERM 169535
SW01 169535
SW02 169535
SW03 169535
STORERM 169775
STORERM 170791
STORERM 170802
STORERM 175253
STORERM 177485
STORERM 179480
STORERM 187384
STORERM 188813
STORERM 190481
STORERM 200017
STORERM 200020
STORERM 200021
STORERM 200024
STORERM 200026
SW02 200026
STORERM 200027
STORERM 200033
STORERM 200034
STORERM 200035
HS01 200036
STORERM 200036
STORERM 200042
STORERM 200047
STORERM 200049
STORERM 200065
STORERM 200070
STORERM 200071
STORERM 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
SW03 200078
Thanks for help.
Bookmarks