View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LenJr LenJr is offline
external usenet poster
 
Posts: 10
Default Track changes by row in different worksheet - History tracking

I am looking for code that would copy a row that a change is being made on to
a separate worksheet. The data being copied would be the data before the
change. I have found code that create tracking base on each change made to
each cell...but I would like to have it base on the entire row of data. Each
row would include a date and time stamp alone with the userName. Column A is
a unique key on the Active worksheet and the history worksheet would hold the
hisotry of changed data. Any ideas would be great. Thanks.