software

Happy New Year!

I have a query that takes share prices from a web site as date in first
column then share prices in following columns across the same row. I then
recorded a macro to take that information from that sheet and insert it to
the next sheet that contains weekly and monthly data tables. On the monthly
and weekly sheet I have made formula’s to figure percentage of change, the
tables collect the data in ascending order (recent dates towards the top of
the table), for the table formula’s I first tried relative then absolute and
finally defined ranges with absolute yet when the data is inserted via the
macro the absolute row’s change they follow the data that they were
originally set with. I really believe it’s doing this because of the date
being in the first cell but I could be wrong. Can you please explain to me
why this is happening?

Thank you!