So i have 2 different file for example file A for person A to enter data and file B for person B. Person A enter data from another place and click macro button and save a file to location where file B is at, as file A' (this i have complete). After that person B must open file A' to copy data to file B.

What i would like to know is: Is there a way after person A enter data and save as file A' and the file automatically enter data from file A' to file B. That will lower the job load of person B a lot.

Thank you.