| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change hyperlink targets in a group of fields at once?
I have a column with 100+ rows where every quarter I change the target of
hyperlinks in each field example Column A all the hyperlinks go to the same row in another sheet and each quarter I add a new column and have to redirect all the old fields to the new column can I change all the hyperlinks to reflect the new Column (N34 to O34) all at once? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I change hyperlink targets in a group of fields at once?
You might try using the Hyperlink Worksheet Function, then
you should be able to change the formulas from the formula view. Another possibility would be to use VLOOKUP with more complicated formulas including the HYPERLINK Worksheet Formula http://www.mvps.org/dmcritchie/excel/vlookup.htm don't think there are any specific examples for that on the page, but it should be possible to concoct something along those lines, it would not be as efficient as just using either form of a hyperlink. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kurk" wrote in message ... I have a column with 100+ rows where every quarter I change the target of hyperlinks in each field example Column A all the hyperlinks go to the same row in another sheet and each quarter I add a new column and have to redirect all the old fields to the new column can I change all the hyperlinks to reflect the new Column (N34 to O34) all at once? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I change hyperlink targets in a group of fields at once?
What is your formula for the hyperlinks now?
"Kurk" wrote: I have a column with 100+ rows where every quarter I change the target of hyperlinks in each field example Column A all the hyperlinks go to the same row in another sheet and each quarter I add a new column and have to redirect all the old fields to the new column can I change all the hyperlinks to reflect the new Column (N34 to O34) all at once? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I change hyperlink targets in a group of fields at once?
Highlight the column, go to Edit Replace, enter the old link in the Find
box, the new name in the Replace box, then Replace (or Replace All!). I don't think Edit Links will work since it will change all the old file names - but it may be worth looking at too. "Kurk" wrote: I have a column with 100+ rows where every quarter I change the target of hyperlinks in each field example Column A all the hyperlinks go to the same row in another sheet and each quarter I add a new column and have to redirect all the old fields to the new column can I change all the hyperlinks to reflect the new Column (N34 to O34) all at once? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I change hyperlink targets in a group of fields at once
Each hyperlink in each field is different except for the Number/Letter of the
column, so that wouldnt work since all I want to change is the Letter in each hyperlink "lk" wrote: Highlight the column, go to Edit Replace, enter the old link in the Find box, the new name in the Replace box, then Replace (or Replace All!). I don't think Edit Links will work since it will change all the old file names - but it may be worth looking at too. "Kurk" wrote: I have a column with 100+ rows where every quarter I change the target of hyperlinks in each field example Column A all the hyperlinks go to the same row in another sheet and each quarter I add a new column and have to redirect all the old fields to the new column can I change all the hyperlinks to reflect the new Column (N34 to O34) all at once? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I change hyperlink targets in a group of fields at once
It's not a formula, it's a hyperlink to another page in the database, the
link grabs the info from another page and shows it on a summary page, there is also a link that if clicked, sends the user to the page and field where the info is grabbed from.... "Barb Reinhardt" wrote: What is your formula for the hyperlinks now? "Kurk" wrote: I have a column with 100+ rows where every quarter I change the target of hyperlinks in each field example Column A all the hyperlinks go to the same row in another sheet and each quarter I add a new column and have to redirect all the old fields to the new column can I change all the hyperlinks to reflect the new Column (N34 to O34) all at once? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I change hyperlink targets in a group of fields at once
What is a hyperlink worksheet function? (dumb question i bet)
"David McRitchie" wrote: You might try using the Hyperlink Worksheet Function, then you should be able to change the formulas from the formula view. Another possibility would be to use VLOOKUP with more complicated formulas including the HYPERLINK Worksheet Formula http://www.mvps.org/dmcritchie/excel/vlookup.htm don't think there are any specific examples for that on the page, but it should be possible to concoct something along those lines, it would not be as efficient as just using either form of a hyperlink. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kurk" wrote in message ... I have a column with 100+ rows where every quarter I change the target of hyperlinks in each field example Column A all the hyperlinks go to the same row in another sheet and each quarter I add a new column and have to redirect all the old fields to the new column can I change all the hyperlinks to reflect the new Column (N34 to O34) all at once? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I change hyperlink targets in a group of fields at once
Look up HYperlink Worksheet Function in your HELP
some examples in http://www.mvps.org/dmcritchie/excel/buildtoc.htm http://www.mvps.org/dmcritchie/excel/buildtoc2.htm http://www.mvps.org/dmcritchie/excel/sheets.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kurk" wrote in message ... What is a hyperlink worksheet function? (dumb question i bet) "David McRitchie" wrote: You might try using the Hyperlink Worksheet Function, then you should be able to change the formulas from the formula view. Another possibility would be to use VLOOKUP with more complicated formulas including the HYPERLINK Worksheet Formula http://www.mvps.org/dmcritchie/excel/vlookup.htm don't think there are any specific examples for that on the page, but it should be possible to concoct something along those lines, it would not be as efficient as just using either form of a hyperlink. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kurk" wrote in message ... I have a column with 100+ rows where every quarter I change the target of hyperlinks in each field example Column A all the hyperlinks go to the same row in another sheet and each quarter I add a new column and have to redirect all the old fields to the new column can I change all the hyperlinks to reflect the new Column (N34 to O34) all at once? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change the label of the total fields in a pivot table? | Excel Discussion (Misc queries) | |||
| Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
| Change Hyperlink to Plain Text | Excel Discussion (Misc queries) | |||
| Hyperlink for a group of addresses without individual entries? | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
