Palmetto, thanks for the code, however when I try and use it, it brings up a macros box, asking which macro to use... what am I doing wrong?
The code I gave is based on your sample workbook and is designed to go into the sheet module and execute when a cell, in the range of B8:B9, changes value. It was not intended to be assigned to a button.

To get a precise solution from the start, you should always post a sample workbook that EXACTLY duplicates the structure of your real workbook. In order to avoid more questions, please upload per the aforementioned.