Excel: Excel1: Complex Macro.


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

* 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 * * * * *
Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4


This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of March 28, 2014.


For more resources for Microsoft Excel