Somebody knows this:
1. Sheet1, cell A1 has a combo box, with 100 list items
When A1 changes value, need macro to:
2. if Sheet1, cell A1 contains value X, then go to cell Y
3. Need this macro to refer to a list on Sheet2, which has the values X & Y, there is just as many of those pairs as list items in combo box. e.g. if portion of Sheet1, cell A1 contains "x1-" then macro should go to cell identified in same row of the Y column, if "x2-", then go to cell identified in corresponding row of the Y column, and so on. Put it another way, need macro to evaluate Sheet1, cell A1 contents, and if part of those contents matches Sheet2, X column, then go to corresponding cell listed in Y column.
Hope this makes sense