Copy data from one open workbook on my PC and paste to another open workbook on another PC

johnsonk

Board Regular
Joined
Feb 4, 2019
Messages
169
Hi, I need to copy data from one open workbook to another open workbook to show the changes instantly, I have tried sharing the workbook in OneDrive but that will not work as the workbook has VBA macros, is there any other way of doing this ?

Regards


EDIT: Should probably mention the workbooks are in the same network folder.
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,118,355
Messages
5,571,693
Members
412,413
Latest member
dvprajapati
Top