merge cells (on a Excell sheet) of selected columns , and only the duplicated values with the sign ; in between the merged cells!
I want to merge cells on excel 2007 but the conditions are :
1. only from 2 selected columns of a sheet say "AA" & "BF",
independent of the number of columns. IN starting row "2"
2. Find only the duplicated values on the "AA" and merge only the opposite value (the other value right or left)
3. with a sign ";" in "red" color between the merged values in the cell
4. the values to be in <<orange>> the 2nd , in <<blue>> the 3rd ,the 4rth in ......
5. and bold all of the cell values that is merged
6. clear content & highlight with background color with in row after merged
7. stop macro when in "AA" column finds cell that is empty.
I have 26 columns , 8000 rows of data
thanks anyone that helps
see example
merge-dup-cell---compare2.xlsx
Don't you think that the colors + background yellow is a bit too much to distinguish the colors ?? If you don't mind I would decide either
Keep the yellow baground and not put colors by duplicate
OR
Remove the yellow background and keep the colors by duplicate.
Last but not least I presume what you want is to select the 2 columns and then press on a button and the macro will produce the results based on what you selected. Is that right ?
Pls advise.
gowflow