OK, here's the scenario I would like to solve. I have multiple sets of data on Sheet1
Sheet1
Set 1 is in A1:A6
Set 2 is in A8:A20
Set 3 is in A22:A30
I would like to be able to do the following:
Click on a cell in Set 1 and it populate cell A1 on Sheet 2.
Click on a cell in Set 2 and it populates cell A2 on Sheet 2.
Click on a cell in Set 3 and it populates cell A3 on Sheet 2.
I would also like the color to change when I click on the cell in Sheet 1. So if I click on A2 on Sheet 1 then A2 on Sheet 1 turns green and whatever is in that cell is now displayed on Sheet 2, A1. But if I reselect say A4, now A2 goes to no color and now A4 is green and that is what is displayed on Sheet 2, A1.
Sheet1
Set 1 is in A1:A6
Set 2 is in A8:A20
Set 3 is in A22:A30
I would like to be able to do the following:
Click on a cell in Set 1 and it populate cell A1 on Sheet 2.
Click on a cell in Set 2 and it populates cell A2 on Sheet 2.
Click on a cell in Set 3 and it populates cell A3 on Sheet 2.
I would also like the color to change when I click on the cell in Sheet 1. So if I click on A2 on Sheet 1 then A2 on Sheet 1 turns green and whatever is in that cell is now displayed on Sheet 2, A1. But if I reselect say A4, now A2 goes to no color and now A4 is green and that is what is displayed on Sheet 2, A1.