Thread: How do I change hyperlink targets in a group of fields at once?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kurk Kurk is offline
external usenet poster
  
Posts: 4
Default 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?

Reply With QuoteReply With Quote