What version of office are you using? On office360 there is the option under properties to move and size with cells whih does what you require. Outside of that you can enable visual basic in excels options then load up the vba ide. There are two dropdown boxes at the top of the code window on the left select worksheet. On the right select change. Inside this subroutine DOCmd.runmacro or application.run sheetname! Macroname.
This will run the macro on change.
At least it should. Something like that anyway.
To Err is Human...
To Arr is Pirate!
