Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) |