Excel Jeanie HTML 4 Last edited by aacod; Mar 28th, 2014 at 06:12 PM. .">
Most valuable professional
  • Hot Topics

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 * 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4 Last edited by aacod; Mar 28th, 2014 at 06:12 PM.

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel