My question is, how can I do the following? There are 200 rows involved. The following explains the question.
Cell A1 has the number 1 in it, cell A2 has 2 in it, cell A3 has 3, cell A4 has 4 Cells B1 has the name name1 in it, cell B2 has name2 in it, cell B3 has name3, cell B4 has name4 Cell C1 is empty, C2 has hame2 in it, cell C3 is empty, C4 has name4 The 2 from cell A2 is copied into cell D1 and name2 from cell B2 is copied into E1 Also the number 4 in cell A4 is copied into cell D2 and name4 from cell B4 is copied into E2. In other words when both Columns B and C have the same name in them then columns A and B are copied to columns D and E and everything that is copied is "compacted" so there are on empty rows between what is copied into columns D and E
