I am using a formula that gives the Relitive strength index of any funds.The formula at J160 gives me the number I need to put in column B in sheet1.
How do I get the number from J160 to move to column B in sheet1?
So far I have linked all the fund symbols in Sheet 1 Column A to Sheet 2 Column
A1. When I run the macro the symbol in Sheet 2 column A1 changes. As it changes the number I need in J160 changes but I can not move the number in
J160 to move to sheet 1 Column B1 then the new number in J160 to move to B2
and so on. Can you give me some help with this one. Thanks
Max Parris