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 -