good2know
New Member
- Joined
- Apr 13, 2013
- Messages
- 1
Hello everybody, Maybe this is a easy question but it what I need, I been trying to find a solution without success. I made a macro, which shows random values from a column already established. (column B). now I want to select that value next to that cell, and display it in a specific cell, click the bottom again. Example if the first randomly cell select B2 of sheet 2 and the result is showed in C2 of sheet 1, in the next click show B3 of sheet 2 and display it in C2 of sheet 1.
The third click repeat the procedure, for example select maybe B7 in the same sheet 2 shows the result in C2, in the next click select C7 in sheet 2 and then shows the result on C2 sheet 1.
I hope someone can help me with this.
The third click repeat the procedure, for example select maybe B7 in the same sheet 2 shows the result in C2, in the next click select C7 in sheet 2 and then shows the result on C2 sheet 1.
I hope someone can help me with this.