tracking changes to cells
how do i do this?
example: when a1 is populated with any value, the time & date of that entry
was made automatically populates a2 and b2 shows the entry. then tomorrow
when a1 is updated, the time & date/update populates into a3/b3. a2&a3
remains the same.
i tried TRACK CHANGES but the history tab kept deleting on every save AND it
wouldnt track changes made on the second sheet of the workbook. maybe i was
doing something wrong.
--
I will Excel at Excel!
|