Hello, 

I am currently working with 20 other colleagues on different excel files and I am wondering if I can create a macro that export my data to their files and then another macro that import their data to my file. 

To be more specific:

On my file I complete columns from A to F, H and I and my colleagues should complete column G, J and K. 

I update my file daily with new leads and, when I export, I do not want to overwrite data on their file, just to ad more rows to the existing ones. And when I make the import to my file, I want to return information on red columns from those 20 excel files. 

Thank you in advance for help!

Here is an example. 

​Hello,  I am currently working with 20 other colleagues on different excel files and I am wondering if I can create a macro that export my data to their files and then another macro that import their data to my file. To be more specific:On my file I complete columns from A to F, H and I and my colleagues should complete column G, J and K. I update my file daily with new leads and, when I export, I do not want to overwrite data on their file, just to ad more rows to the existing ones. And when I make the import to my file, I want to return information on red columns from those 20 excel files. Thank you in advance for help! Here is an example.     Read More

​