Revision Tracking

  • Thread starter Thread starter arunsharm82
  • Start date Start date
A

arunsharm82

Hi all,

I am trying to make a spreadsheet that can track changes that I make t
certain cells.

For example, I have a list of Task Numbers, that are unique, and I wan
to be able to make people type in an explanation if they make change t
the task number in a separate comments column.

I want it to not let a person carry on if they change a task number an
not log the change in the Comments field.
I.e. Task numbers in column A and Comments in Column C

Is this type of thing possible?

Thanks in advance, because you guys know everything!!!!!:cool
 
You can use the track changes (which will also share your workbook) an
a history file is kept. It will track who made changes, when, what cel
was changed, and the old and new values in that cell. However, I don'
think there is a way to force people to fill in a comments field i
they make a change.

You could of course manually review the log (not sure abou
automatically reviewing it...macro maybe??) and whenever a cell with
Task Number is changed look for a corresponding update to your commen
cell. It would have to be as an audit function as I don't think you'
be able to do it real-time
 
Thanks for the advise, but I really need something that works in rea
time. With this method you can create a log of the changes made, on
new sheet, but when you go to save it the new page with the log o
changes gets deleted, so it is not really a viable solution.

Does anybody else have any ideas?

Thanks for your help
 
Send me your email address and I'll send you a
spreadsheet with a macro that does just what
you want.
jlr
 
Back
Top