Hi,
We use a Workbook for recording Vehicle times outbound (Loading Time, Day, Driver, Destination, Vehicle Registration Etc. Etc.)
The workbook has 1 tab for each day of the week, 1 Spreadsheet for each Week, 4 Spreadsheets for each Period.
I would like to build a simple 1 tab spreadsheet as a lookup feed for Sunday Commencing dates, All Vehicles Registrations, Trailer ID's, Employees.
Basically a list for each that feeds the dropdowns on each spreadsheet above (Data Validation)
How would I go about linking the feed in Office 365 Excel/SharePoint? (excel data validation list from a central source feed spreadsheet stored in the same OneDrive folder)
Is it possible?
Is there any workarounds for such a task, would SharePoint Lists help?
Thanks in advance
Trunking Log.jpg
Bookmarks