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

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Watch MrExcel Video

Forum statistics

Threads
1,118,311
Messages
5,571,495
Members
412,397
Latest member
Phillip Rogers
Top