I have a spreadsheet with many sheets and i need to link back data from one point to another .

Let me elaborate my needs

Say that i have two cells which have data validation in them comprising of a list

Cell A1 has list of values namely
Test 1
Test 2
Test 3

Similarly Cell B1 has list of values
Option 1
Option 2


Now i can have six combination of selections between these two cells which should lead me to six different cell locations

I have a button to which i intend to assign a macro on click. again i am pretty bad at macros and am a novice , so request the Guru's to help me out.

So depending upon the Combination of values chosen ( Test1-Option 1; Test 1 - Option 2 and so on) i want the button to redirect me to the designated cell within the spreadsheet. Do i need to create a reference table with all combinations and specify the respective cell address and then add code around it? again i have no clue on the syntax or how to code . so please help me on this.


Thanks,
Prash