aacod
Well-known Member
- Joined
- Mar 20, 2009
- Messages
- 667
Under column A from cells 2 to 85000 I have multiple duplicate entries: e.g. INT, INT, INT.
In the corresponding cells under column B for all the INT, it means Internal, International, Interval.
I need a macro that would identify all duplicate entries in Column A, copy the contents from corresponding cells in column B and paste to one of the cells corresponding to ‘INT’ in column B separated by ‘Or’. e.g. as follows:
Sheet1
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4
In the corresponding cells under column B for all the INT, it means Internal, International, Interval.
I need a macro that would identify all duplicate entries in Column A, copy the contents from corresponding cells in column B and paste to one of the cells corresponding to ‘INT’ in column B separated by ‘Or’. e.g. as follows:
Sheet1
* | A | B | C | D | E |
1 | * | * | * | * | * |
2 | * | * | * | Befor Macro | * |
3 | * | * | * | * | * |
4 | INT | Internal | * | * | * |
5 | INT | International | * | * | * |
6 | INT | Interval | * | * | * |
7 | * | * | * | * | * |
8 | * | * | * | After Macro | * |
9 | * | * | * | * | * |
10 | INT | Internal or International or Interval | * | * | * |
11 | * | * | * | * | * |
12 | * | * | * | * | * |
13 | * | * | * | * | * |
14 | * | * | * | * | * |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4
Last edited: