Tenspeed39355
02-17-2005, 01:51 PM
I would like to link 450 stock symbols to an another sheet.
I have 450 fund symbols in Sheet2 A3:A455. I want to link each one to
Sheet1 A1. How can I do that without linking each one seperately.
I started by using the copy in Sheet2 A3 and then going to Sheet1 A1 and
doing a paste special and selecting the LINK. Is there a way to link all the
symbols by using a macro or some other method?
Thanks for your time
Max:hi:
I have 450 fund symbols in Sheet2 A3:A455. I want to link each one to
Sheet1 A1. How can I do that without linking each one seperately.
I started by using the copy in Sheet2 A3 and then going to Sheet1 A1 and
doing a paste special and selecting the LINK. Is there a way to link all the
symbols by using a macro or some other method?
Thanks for your time
Max:hi: