PDA

View Full Version : Workbook to track changes in other workbooks



reza_doang
06-28-2010, 03:06 AM
Hi All,


Each person must record in there production sheet how much time they spent doing their daily tasks before they leave for the day. Currently we use Track changes to verify that they filled out their sheet on time. I am looking for a way to have each production sheet (joe, sarah, bob) coded so that when something is changed in it, that column that the information was changed in will be copied to a main (master prod) including a time stamp and user name that changed it.
Worksheet looks like this: Worksheet is named by month Row B is dates (starting at b2 and showing each day of the month), column A is what you did,
Master sheet should be like this: Who made change, Timestamp of when change was made, column from individual production sheet that was changed.