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!
 

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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?
 
Joined
Dec 13, 2016
Messages
3
Reaction score
0
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

Top