The procedure is part of the ThisWorkbook Object. In the Project
Explorer you can find the ThisWorkbook Object Module. Here you should
put the Subroutine. In this Object Module you can find all the Events
of the Workbook Object, in the Picklist on the upper right (make sure
you picked Workbook in the other picklist left of it first).

Other then that it looks like it would work, if I am interpreting it
right (as an aside, is it possible to get backfill for a cell to copy
as well).

What do you mean with backfill?

Bart