Macro to refer to a spreadsheet for iF, Then conditions

  • 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

  • Attach your workbook, would be easier than trying to follow your explanation.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Simplified: 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.

    e.g. Sheet1, cell A1 has "x1 - abc". Macro needs to find "x1" in Sheet2, X column and go to cell A20 on Sheet1, because that's what's listed in Y column in the same row with x1 listed in X column. @KjBox

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!