ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro to compare and retrieve data (https://www.excelbanter.com/excel-programming/417899-macro-compare-retrieve-data.html)

tcur60

macro to compare and retrieve data
 
I have 3 sets of data with 3 columns each on a single worksheet.
A B C D E F G H I
I need to find when the # in column A = # in D = # in G and the # in B = # in
E = # in H. After finding the matching data sets I would like to create a
table listing the matching numbers along with the numbers in columns C, F & I.
The trick is that the matching data sets (A/B & D/E & G/H) are in different
rows. Can anyone help me with this? Thanks in advance - TC



All times are GMT +1. The time now is 01:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com