Please .... Search, Match and compare
Posted by Marc Hennebery on May 11, 2001 1:39 PM
I have two workseets that come from two different sources. I need to match an Item number in column A of Sheet1 with Column A of Sheet2. When there is a match found, I need to place the two item numbers along with the data found in Column I of Sheet1 and Column G of Sheet2 of the matching records in a row on Sheet3. Can this be done with a macro, or is this something better done with a formula? Please help me out with this.