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