Hi I need to store utility meter readings for multiple different meters. I was wondering if it was possible via excel to each time you enter a new reading the previous reading was stored on another sheet, so the meter readings for the meter were being collated, but on the front sheet just the most recent reading was shown.
Solved by M. E. in 24 mins