Hi Troy,
You probably want your macro that Otto started you
off with information on how to write the macro to first bring
what you have up to date.

Then for updating you will want an Event Macro.
http://www.mvps.org/dmcritchie/excel/event.htm

If you have your comment indicators turned on, it not much
problem to see which cells have or do not have comments
and to see or add them accordingly if his is jus for one sheet
and you're not constantly adding/changing comments...
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm