Hyperlinks

H

Hardeep_kanwar

I have 1 Master sheets and there are 400 Company name with there detail.

I make the worksheets according to there Company Name in the same workbook
i.e. 400 worksheets.

Now i want to apply the hyperlinks on all the Company Name in Master Sheets.
Now when i click on Company Name (A1) then it will open that Particular
Sheet.

My Question is- Is it Possible to apply HYPERLINKS to all the company Name
for giving the one Command Or i have to go with Manually means Applying
HYPERLINKS One By One.

As i mentioned above that there is 400Worksheet.

Any Help will be Appreciate.

Thanks In Advance

Hardeep Kanwar
 
P

Pete_UK

Assuming your company names are in column A, put this in B1:

=HYPERLINK("#'"&A1&"'!A1,A1)

then copy down your 400 rows. You will have the name in column B as a
clickable hyperlink which will take you to cell A1 in the appropriate
sheet. Note the apostophes in the formula - one after # and one
before !

Hope this helps.

Pete
 
H

Hardeep_kanwar

Dear Sir

Thanks for the quick reply

but when i entered this Formula in Bi. It Show the ERROR MESSAGE(THE FORMULA
YOU TYPED CONTAINA AN ERROR)

Hardeep kanwar
 
P

Pete_UK

Instead of typing it, copy it from the newsgroup posting and paste it
into the formula bar.

Pete
 
P

Pete_UK

Just had a thought - you might use semicolons instead of commas to
separate the parameters, so you might like to try this version:

=HYPERLINK("#'"&A1&"'!A1;A1)

Hope this helps.

Pete
 
P

Pete_UK

Okay, here's a modification to the formula:

=HYPERLINK("#'"&A2&"'!A2";A2)

I missed the quotes after the second A2.

However, your sheet names in column A must be exactly the same as what
you have used - your first one has "n/w" at the end of it.

Hope this helps.

Pete
 
H

Hardeep_kanwar

Thanks Sir,

It works Gr8

Hardeep kanwar

Pete_UK said:
Okay, here's a modification to the formula:

=HYPERLINK("#'"&A2&"'!A2";A2)

I missed the quotes after the second A2.

However, your sheet names in column A must be exactly the same as what
you have used - your first one has "n/w" at the end of it.

Hope this helps.

Pete
 

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

Top