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

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

On Nov 6, 3:38*pm, Hardeep_kanwar
wrote:
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

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" wrote:

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

On Nov 6, 3:38 pm, Hardeep_kanwar
wrote:
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

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

Pete

On Nov 7, 4:05*am, Hardeep_kanwar
wrote:
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" wrote:
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

On Nov 6, 3:38 pm, Hardeep_kanwar
wrote:
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- Hide quoted text -

- Show quoted text -

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

On Nov 7, 9:38*am, Pete_UK wrote:
Instead of typing it, copy it from the newsgroup posting and paste it
into the formula bar.

Pete

On Nov 7, 4:05*am, Hardeep_kanwar



wrote:
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" wrote:
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

On Nov 6, 3:38 pm, Hardeep_kanwar
wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

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" wrote:

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

On Nov 7, 9:38 am, Pete_UK wrote:
Instead of typing it, copy it from the newsgroup posting and paste it
into the formula bar.

Pete

On Nov 7, 4:05 am, Hardeep_kanwar



wrote:
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" wrote:
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

On Nov 6, 3:38 pm, Hardeep_kanwar
wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

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


On Nov 7, 3:50*pm, Hardeep_kanwar
wrote:
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" wrote:
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

On Nov 7, 9:38 am, Pete_UK wrote:
Instead of typing it, copy it from the newsgroup posting and paste it
into the formula bar.

Pete

On Nov 7, 4:05 am, Hardeep_kanwar

wrote:
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" wrote:
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

On Nov 6, 3:38 pm, Hardeep_kanwar
wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Thanks Sir,

It works Gr8

Hardeep kanwar

"Pete_UK" wrote:

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


On Nov 7, 3:50 pm, Hardeep_kanwar
wrote:
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" wrote:
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

On Nov 7, 9:38 am, Pete_UK wrote:
Instead of typing it, copy it from the newsgroup posting and paste it
into the formula bar.

Pete

On Nov 7, 4:05 am, Hardeep_kanwar

wrote:
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" wrote:
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

On Nov 6, 3:38 pm, Hardeep_kanwar
wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

You're welcome - thanks for feeding back.

Pete

On Nov 10, 3:31*pm, Hardeep_kanwar
wrote:
Thanks Sir,

It works Gr8

Hardeep kanwar