2 Columns of data will be provided ( Option String 1 & Option String 2 ).
On the click of the "Run" button ( button to be created ), a MACRO will create the 3rd column of Common string.
The cells under the Common String column must contain the common codes ( eg, CF5, CW2 etc.... ) from the first 2 columns and must be separated by comma in alphabetical order.
Option String 1
27I,CF5,CW2,L98,M32,PDP,U32,UV9
27I,CF5,CW2,L98,M32,PDP,UV9
51I,CF5,CW2,L98,M32,PDP,U32,UV9
51I,CF5,CW2,L98,M32,PDP,UV9
27I,CF5,CW2,L98,M32,PDP,U32
27I,CF5,CW2,L98,M32,PDP
Option String 2
CF5,CW2,L98,PPO
L98,M32,PDP,APO
L98,M32,PDP,XCU
CF5,CW2,L98,M32
L98,M32,PDP,RTY
CF5,CW2,L98,M32
***VERY URGENT SOMEBODY HELP ME***
Bookmarks