Hi,
How would you write a macro that would insert a hyperlink in column L via a condition where:
- any cells in column h(x) is >1000
and where the the actual link is ""columnJ(x)"" where the text in column J is blue (a hyperlink)....
an example
cell h2 = 1003, cell j2= text then in cell L2 insert hyperlink called "text.xls"
cell h3 = 993, cell j3 = text1 then insert no hyperlink.
Jay
How would you write a macro that would insert a hyperlink in column L via a condition where:
- any cells in column h(x) is >1000
and where the the actual link is ""columnJ(x)"" where the text in column J is blue (a hyperlink)....
an example
cell h2 = 1003, cell j2= text then in cell L2 insert hyperlink called "text.xls"
cell h3 = 993, cell j3 = text1 then insert no hyperlink.
Jay