Is it possible to update one excel workbook (or sheet) with changes (values en formulas) which are inserted into another workbook (or sheet).
The problem is that 2 my colleagues have each updated their own file separately. Now we have to put them into one. Is it possible to merge them / synchronize them into one without old fashioned function copy-paste?
Your help will be highly appreciated!! Thanks in advance!