Forum Discussion
Link master list to multiple workbooks
I'm using excel to track my customers and currently run 2 workbooks with the same information, however every day one of the workbooks changes. Rather than re-enter new information can I link the info...
If the values are in a consistent place every day, you could just link the values (like below):
='C:/Documents/[Truck Transfer Ticket 3.xlsx]Schedule'!$F$340
You would just need the path of the workbook as well as the sheet and range that the values are stored on.
- Thanks I did end up doing that for now, just felt there must be a better way.
