Hyperlinks
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 |
Hyperlinks
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 |
Hyperlinks
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 |
Hyperlinks
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 - |
Hyperlinks
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 - |
Hyperlinks
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 - |
Hyperlinks
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 - |
Hyperlinks
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 - |
Hyperlinks
You're welcome - thanks for feeding back.
Pete On Nov 10, 3:31*pm, Hardeep_kanwar wrote: Thanks Sir, It works Gr8 Hardeep kanwar |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com