@mdmackillop
I didn't even consider the possibility of macro events - that could have turned into a mess real fast!
I struggled with stepping back and forth between the workbooks. Other than the activate and select methods how is this supposed to be achieved?