How to associate and mass edit all fields between 2 columns?

**illuminate** · 05-29-2015, 12:51 AM

Hello,
I have been trying for a while to achieve this without any success:

1. https://www.dropbox.com/s/95crj0t58s...27.17.png?dl=0 in this scenario take data in B column and add them all into the field B138 with ";" separation. (example: Loop;Open Loop;Padded Open Loop;Padded T-Bar)

A) if there is something like this https://www.dropbox.com/s/sigqa4oi5g...29.41.png?dl=0 then make sure it does the #1 function only to the options that belong to the associated A column value. (notice the separate colors https://www.dropbox.com/s/v24a3ezk0x...32.31.png?dl=0)

I am not sure if this will be a single VBA or multiple VBA scripts.
Thank you

**Leith Ross** · 05-29-2015, 01:30 AM

Hello illuminate,

Welcome to the Forum!

You can post your workbook here. It is better to have the workbook for testing solutions rather than try to recreate what you done.

How To Post Your Workbook

At the bottom right of the Reply window, Click the button Go Advanced
At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
Click the Select Files button at the bottom middle of the dialog.
In the new window Find the file you want to upload, select it, and Click Open.
You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
Wait until the file has completely uploaded before you exit the File Manager dialog.

**Leith Ross** · 05-29-2015, 01:30 AM

Hello illuminate,

Welcome to the Forum!

You can post your workbook here. It is better to have the workbook for testing solutions rather than try to recreate what you done.

How To Post Your Workbook

At the bottom right of the Reply window, Click the button Go Advanced
At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
Click the Select Files button at the bottom middle of the dialog.
In the new window Find the file you want to upload, select it, and Click Open.
You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
Wait until the file has completely uploaded before you exit the File Manager dialog.