Hi sktneer,

This works very well but I prefer having the pending sheet update automatically when opened rather than having to press a button.

Many thanks for your help though!

Steven