I need to create a duplicate workbook on a different shared drive...this duplicate workbook needs to be updated and current with the data entered on my original copy which is on a different shared drive.
To further explain...I have a workbook on my own personal drive. But they want it to be available on a different shared drive with the continually updated information that enter throughout the day. So when someone looks at the workbook on the shared drive, they see the same workbook that I have with all the updates and new info that I have entered at any given time.
How do I reference or link the 2 workbooks so that any info entered on my source workbook shows on the workbook on the shared drive?
A sample of the workbook is attached in case you need it...
THANKS in advance for any help!
Sample.xlsx
Bookmarks