cell to cell hyperlink with a word

[lightv2]

All,

I am currently in charge of my fantasy pickem league.

I have a great spreadsheet to set my teams up with, is there a way i can create a formula, or ANYTHING, to click on a team name as a pick, and move it from one cell to another?

for example:
cell a1=carolina
cell a2=pittsburgh
cell b1=(blank)

i want to click on the team that i think is going to win, A1=carolina, and have that click put carolina's name in cell b1.

is this possible?

[JP Romano]

You could put something in the "ThisWorkbook" module like below - this will, on double click, copy the activecell and paste it into the cell immediately to the right.

Please Login or Register  to view this content.

or you could do this to move it entirely

Please Login or Register  to view this content.

Probably not the best solution, but it's easy and worked fine for me!

[lightv2]

how do i fill that in....i'm a beginner at excel stuff

[JP Romano]

No worries...
Alt + F11 to open the vba editor.
On the left side of the screen (Project Explorer) look for the name of your file (it'll be something like VBAProject(filename), then the module called "ThisWorkbook"
Then just paste in the code from the last post and save. Then try it out!