View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ms_M_o_n_i_c_a Ms_M_o_n_i_c_a is offline
external usenet poster
 
Posts: 13
Default 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!