Hyperlinking each cell of Col A in Workbook 1 to the Worksheet in Workbook 2 with the same name

[eddiecruz]

I searched and searched. Now, I humbly ask.

Workbook A has a column with 200 text entries; the first few cells are Tom, ****, Harry, Mary, Mickie, Moe, Dot.

Workbook B has 200 worksheets, and the first 7 are called, respectively, Tom, ****, Harry, Mary, Mickie, Moe, Dot.

I want to click cell "Tom" and jump to worksheet "Tom"; cell "****" and jump to worksheet "****" and so forth. I can do the hyperlinking one at a time, but in the 21st century, surely this can be done more efficiently. I don't even know where to start.

Any help is much appreciated.

 

[eddiecruz]

I searched and searched. Now, I humbly ask.

Workbook A has a column with 200 text entries; the first few cells are Tom, Rick, Harry, Mary, Mickie, Moe, Dot.

Workbook B has 200 worksheets, and the first 7 are called, respectively, Tom, Rick, Harry, Mary, Mickie, Moe, Dot.

I want to click cell "Tom" and jump to worksheet "Tom"; cell "****" and jump to worksheet "****" and so forth. I can do the hyperlinking one at a time, but in the 21st century, surely this can be done more efficiently. I don't even know where to start.

Any help is much appreciated.

EDIT: Apologies. Excel 2010, Win 7. (Couldn't locate the EDIT button to do this properly)

 

[eddiecruz]

Linkback: Hyperlinking each cell of Col A in Wrkbk 1 to the Sheet in Wrkbk 2 with the same name

(I hope I'm doing this correctly.)

 

[eddiecruz]

Solved, and two thousand thank yous to bulina2k.

Hyperlinking each cell of Col A in Wrkbk 1 to the Sheet in Wrkbk 2 with the same name [SOLVED]