Hi I have a problem that I don't think the "indirect" or "offset" function can help (I could be wrong)
I have created a macro that collects market data on a daily basis and inserts a new row (Row 2) with a time stamp and all kinds of various market data in different columns. The goal of this is to track performance after one day (A2-A3)/A2) after 30 days (A2-A30)/A30) and after 6 months 1 year etc.
The problem is that when the macro inserts a new row, it changes the cell references (putting absolutes doesn't help either).
If someone could help me out with this it would be enormously appreciated!
I have created a macro that collects market data on a daily basis and inserts a new row (Row 2) with a time stamp and all kinds of various market data in different columns. The goal of this is to track performance after one day (A2-A3)/A2) after 30 days (A2-A30)/A30) and after 6 months 1 year etc.
The problem is that when the macro inserts a new row, it changes the cell references (putting absolutes doesn't help either).
If someone could help me out with this it would be enormously appreciated!
