How do you use vba with a two column spreadsheet? If i want vba to check cell A1 to see if it contains a value matching any in the first column, and then scroll to the cell listed in corresponding row of second column? In example below, if A1 contains: "x1", then scroll to cell A200; if x2, then scroll to A555
Where:
A1 is on Sheet1
Two column spreadsheet is on Sheet2
x1 A200
x2 A555
x3 A1000
