Create Multiple Hyperlinks in Excel

B

BarryGower

I am trying to link two worksheets using hyperlinks. The first
worksheet ( Worksheet1) has a field CompanyCode and contains sales
information . The second worksheet (Worksheet2) has the same field
CompanyCode and all the company address details. The two worksheets
are in exactly the same order.

I would like to create a hyperlink in Worksheet1 linking the
CompanyCode to Worksheet2 and then copy all the hyperlinks by
dragging . Is this possible, or is there another simple way of doing
this. (It has to be simple - I am not too good on macros or VB!)

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named Ranges -- Link Issue? 2
Embed the same Excel multiple times 0
matching multiple columns on different worksheets 1
Quickly moving down one row on pasted data from another worksheet. 4
Retuyrning a single entry when multiples of the same 3
DBSUM function but with function as criterion, not a range 3
Data consolidation from Multiple Sheets 1
Merging data from Multiple Worksheets 0

Top