Hi Marcheese,
Try placing the following code in the ThisWorkbook section. It will run automatically any time there is a change made on your sheet is the only potential problem. How do you update the values from the other workbook? Are the links initially updated when you open Bud vs Act or do you manually update them? Think this is the bit that gives me a problem making it run automatically but hopefully the following will work ok for you.
I also removed the "END" from column A so it now stops when it gets to the row saying "Group Insurance" in Column B however you can change this if your sheet changes at all
Mowgli
Bookmarks