Hi, attached a sample. My Sheet1 is the data sheet where the Match lookup range is (Row 1 and Column A). Sheet2 is where the Report is generated. I want to trigger the marco wheneevr Sheet2 Row 1 or Column A is change. The marco shall match the value in the Row and column from Sheet1 (lets say the Mary A), Then Sheet1.C2 value will be shown in H2 of Sheet2.
Of coz, in Row1/ColumnA of sheet2, there will be other value where the match will produce error. Wheenever there is error, the marco shall look at the next value.
Bookmarks