Storing changing data

[caltex]

How to store changing data in Excel?. For instance I need to store daily an input data in one cell. Then I need to copy the data in another cell because the next day the data is changing. At the end I need to average all data for the month. Somebody can help me. Thanks

 

[Derek Brown]

Hello and welcome to The Board.
I see that you have not had any replies to your post yet - perhaps it would help if you can give more information.
Looking at what you have already described, it would seem that all you have to do is use two columns - one for the date and the other for the data (you indicate that you are only using one cell each day). All you would have to do is add the new data to the bottom of the existing data in the column.

 

[caltex]

To be more clear i have solved with a macro that go a new worksheet, insert one line, insert a new line in the same line, copy the content of the cell receiving the data and delete one line below the line inserted. There is any other way?

Hello and welcome to The Board.
I see that you have not had any replies to your post yet - perhaps it would help if you can give more information.
Looking at what you have already described, it would seem that all you have to do is use two columns - one for the date and the other for the data (you indicate that you are only using one cell each day). All you would have to do is add the new data to the bottom of the existing data in the column.