Updating a table that is linked to a cells value

Hi guys,

I have a table of data, one column with "date" and one column with "profit" that takes the value from one specific cell (say A1), which is a summation of two other cells (say A2 and A3) and is changing value all the time due to lots of other calculations.

Every time I refresh A1, and by "refresh" i mean, i have to go in to its formula bar and then back out of it (hit "enter"), the table adds a knew row with A1's current value and the current date. Which is obviously messy and annoying

I was wondering if there was a way to get this to happen on a schedule Ie. i want to update the table every 24hours with A1's value at that time.
OR a way for it to be done without having to physically go into the cells formula bar to update the table. For example, with a button with a macro or something.

Is there a way i can do this?

Thanks,
Cam

Cam,

Can you upload an example of your sheet, it would help make it easier to understand what you are trying to achieve.