Hyperlinks

[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

 

[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

 

[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

 

[Pete_UK]

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

Pete

 

[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

 

[Hardeep_kanwar]

http://www.savefile.com/files/1875611

Kindly find the Attached file. In which i copy the formula which is given by
you.But still it show the ERROR.

Thanks
Hardeep

 

[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

 

[Hardeep_kanwar]

Thanks Sir,

It works Gr8

Hardeep kanwar

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

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete