Macro- Hyperlink from cell value to tab
Hello,
I have a list of values (approx. 250 customer names, A2:A250).
Through another macro I found online, I created a tab for every single one of these customers (for further information and details). The tabs and values in the cells are exactly the same.
I have no idea about how to program VBA or any other language.
What I am trying to do is to get a hyperlink from the customer name to the corresponding tab.
Any chance someone could help, please?
Much obliged,
Lobo123
CREATE SHEETS
Here's a macro for creating an ordered set of sheets based on a column of strings AND add clickable hyperlinks in an adjacent column, basically a linkable index sheet. There's a sample sheet to try it on:
Create Sheets
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
You've got already one:
go to the navigation buttons in the window's left down corner: click the rightmouse: et voilà
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks