Good Afternoon all (or good morning depending where you are (I'm working on GMT)),


I’m after somehelp regarding some VBA code I am trying to put together, I believe the variousaspects are feasible but I don’t have the knowledge of how to putit all together; I’m hoping someone can help me here.


Therequirements of the macro are as follows:


  1. The macro is triggered every time the file “x” is saved by a user (multiple users will have access to this file)
  2. Upon trigger, the 1stsheet of x, called “Summary” is copied and the values are pasted into another pre-existing file “y” on a specified sheet “x summary” - this should overwrite the information already on the “x summary” sheet every time it is saved.


Any ideas / solutions are welcome.

Thanks