I am trying to come up with a way to automatically update current cell values
when I make a new entry for my spread sheet. For example, I have a
comprehensive list of numbers that represent miles of vechiles in several
different worksheets and I need to always display the most current mileage
from each vechile on the front page. However whenever I make a new entry, I
need that new number to replace the old value on the front page. I know how
to link the cells from the other worksheets to the front page, however what I
can't figure out is how to make it so that I can simply type in the latest
entry, and have it automatically update into another cell on the front page.
So my question is, does anyone know how to automatically replace current,
existing numbers in a cell with a new more recent entry???? I want it to be
so that I can keep updating the info regularly, but without having to worry
about always typing in the most current milage in the front page, I want this
to happen automatically whenever there is a new entry.