Hyperlink + dragging?
First, sorry for my english, I'm brazilian and it's not perfect. So, I'm working in some worksheets that show over 4000 products (lines). I want to create a hyperlink that takes the reader towards the products informations located in plan2. Once I'm having the product codes in both plans, is there a way to repeat the function (matching the codes correctly) or I'll have to do one by one?
Thank you very much!
Don't use the CTRL-K hyperlink feature that imbeds hardcoded hyperlinks into the cell.
Use the HYPERLINK() formula to construct your hyperlink from string on the row. The copying that cell down could adjust itself to create links for the data unique to each row.
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks