Attached is the "xlsm" file that I should have attached to my first post.
It contains several methods that I am testing, but the one I am having trouble with is the VBA to update a cell when the cell at a target address changes.
Thanks much.
FergBPTrack test.xlsm