Hi All,
I have a question regarding automatic merging in VBA. Its similar to this thread (http://www.mrexcel.com/forum/excel-...tically-merge-vertically-identical-cells.html) but with a slight twist.
So say if I have four columns set up as follows, where the first line contains headings (before)
<col width=80 style='mso-width-source:userset;mso-width-alt:2925;width:60pt'> <col width=79 style='mso-width-source:userset;mso-width-alt:2889;width:59pt'> <col width=44 style='mso-width-source:userset;mso-width-alt:1609;width:33pt'> <col width=85 style='mso-width-source:userset;mso-width-alt:3108;width:64pt'>
<![if supportMisalignedColumns]>
<![endif]>
Im looking for something like this (please ignore the periods as i had to put them to keep the table from incorrectly displaying).
I'd like to highlight the non-merging of Striker (line 7 and 8 in column2) becasue one belongs to Manchester and the other to Arsenal
<col width=64 span=4 style='width:48pt'> <col class=xl6522403 width=64 style='width:48pt'>
<![if supportMisalignedColumns]>
<![endif]> </div>
I have a question regarding automatic merging in VBA. Its similar to this thread (http://www.mrexcel.com/forum/excel-...tically-merge-vertically-identical-cells.html) but with a slight twist.
So say if I have four columns set up as follows, where the first line contains headings (before)
Team | Position | Salary | Term (years) |
Arsenal | Goalkeeper | 100 | 1 |
Arsenal | Goalkeeper | 100 | 1 |
Arsenal | Goalkeeper | 50 | 2 |
Arsenal | Midfield | 50 | 2 |
Arsenal | Midfield | 50 | 2 |
Arsenal | Striker | 25 | 2 |
Manchester | Striker | 25 | 2 |
Manchester | Striker | 25 | 3 |
Manchester | Striker | 25 | 3 |
Manchester | Manager | 25 | 1 |
Manchester | Manager | 25 | 1 |
Manchester | Manager | 30 | 1 |
Chelsea | Manager | 35 | 2 |
Chelsea | Staff | 35 | 2 |
Chelsea | Defender | 25 | 2 |
Chelsea | Defender | 25 | 2 |
Chelsea | Striker | 25 | 2 |
Chelsea | Striker | 25 | 2 |
<col width=80 style='mso-width-source:userset;mso-width-alt:2925;width:60pt'> <col width=79 style='mso-width-source:userset;mso-width-alt:2889;width:59pt'> <col width=44 style='mso-width-source:userset;mso-width-alt:1609;width:33pt'> <col width=85 style='mso-width-source:userset;mso-width-alt:3108;width:64pt'>
<![if supportMisalignedColumns]>
<![endif]>
Im looking for something like this (please ignore the periods as i had to put them to keep the table from incorrectly displaying).
I'd like to highlight the non-merging of Striker (line 7 and 8 in column2) becasue one belongs to Manchester and the other to Arsenal
Team | Position | Salary | Term (years) | |
Arsenal | Goalkeeper | 100 | 1 | |
. | . | . | . | |
. | . | 50 | 2 | |
. | Midfield | 50 | 2 | |
. | . | . | . | |
. | Striker | 25 | 2 | |
Manchester | Striker | 25 | 2 | |
. | . | . | 3 | |
. | . | . | . | |
. | Manager | 25 | 1 | |
. | . | . | . | |
. | . | 30 | 1 | |
Chelsea | Manager | 35 | 2 | |
. | Staff | 35 | 2 | |
. | Defender | 25 | 2 | |
. | . | . | . | |
. | Striker | 25 | 2 | |
. | . | . | . | |
<col width=64 span=4 style='width:48pt'> <col class=xl6522403 width=64 style='width:48pt'>
<![if supportMisalignedColumns]>
<![endif]>