View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HarryisTrying HarryisTrying is offline
external usenet poster
 
Posts: 22
Default track row changes with date and time stamp

I looked at a similiar request called "Track changes by row in different
worksheet - History tracking" that was posted previously and tried to modify
it.

What I would like to do is take my 37 column spreadsheet with a header row
and anytime any cell in a row is changed write the original row to the
History Sheet with the user ID (network) and a date and time stamp. I would
like the header row to be in the History file. If the ultimate was available
the changed cell(s) would be highlighted with a different color.
--
Thank You