Excel In Excel how can I save a value on daily basis

Joined
Dec 13, 2016
Messages
3
Reaction score
0
hello everyone!

In Excel I have A1 that change on daily basis, I have to save it's value in B1 for Monday, B2 for Tuesday and so on day by day saving the value for the day before.
It's that possible?
Now, I tried what I can but I can't reach what I want!
 
I'm not sure what you are asking here - do you want the data to automatically save in the relevant cell?

Where is the changing (daily) data coming from? Within the spreadsheet?
 
Sorry, It wasn't clear at all!
I'm trying to make another example.
I have a sheet where I count all the part I have in my shelf, I do this every day.
I'd like to take the daily results and, perhaps with a formula or something like that, automatically saving the value in another sheet for make a monthly and yearly average.
 
Back
Top