-
VBA code: copy data from sheet and paste values onto another specidied workbook
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:
- The macro is triggered every time the file “x” is saved by a user (multiple users will have access to this file)
- 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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules