Forum Discussion
Excel - Macros
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 t...
Hi,
Re:want to return information on red columns from those 20 excel files.
If you do not frequently sync master sheet and subsidary sheets,you can copy all sheets to your local PC and merge/split with VBA or Power Query.
If you want to imediately sync all datas,I am afraid you need a database to share which similar to
https://club.excelhome.net/forum.php?mod=viewthread&tid=1520437&mobile=