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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top