Hi all,
I've got a situation where my office has put together a basic timesheet using an Excel spreadsheet. Currently, users have to manually type each relevant project code, but I wanted to improve upon this (and some other things) by providing a drop-down list for users to choose and also display the name of the project in the adjacent cell to the right, to help ensure the correct project number was chosen. I achieved this creating another sheet where I made a table with 2No. Columns, Project Number and Project Name, and using Data Validation. When the Project Number is chosen from the drop-down, the adjacent cell displays the relevant Project Name, this all works as intended. The problem I have is that our office is head office small and we have people working around the country, either at home or on site, and if the project list was to be updated, I'd have to reissue the XLS file to everyone via email again. What I'm hoping to do is find a way to store the Project Number and Names online, and have that data be read whenever the XLS is opened. I'm looking for suggestions as what the best approach would be to achieve this, and hopefully avoiding any IT issues/restrictions along the way. An alternative approach I had considered was issuing an XLS with the project data every so often via email, and users copy & overwrite the existing file to the root of their documents folder, but that seemed to involve issues with Trusted Locations etc...
I've got a situation where my office has put together a basic timesheet using an Excel spreadsheet. Currently, users have to manually type each relevant project code, but I wanted to improve upon this (and some other things) by providing a drop-down list for users to choose and also display the name of the project in the adjacent cell to the right, to help ensure the correct project number was chosen. I achieved this creating another sheet where I made a table with 2No. Columns, Project Number and Project Name, and using Data Validation. When the Project Number is chosen from the drop-down, the adjacent cell displays the relevant Project Name, this all works as intended. The problem I have is that our office is head office small and we have people working around the country, either at home or on site, and if the project list was to be updated, I'd have to reissue the XLS file to everyone via email again. What I'm hoping to do is find a way to store the Project Number and Names online, and have that data be read whenever the XLS is opened. I'm looking for suggestions as what the best approach would be to achieve this, and hopefully avoiding any IT issues/restrictions along the way. An alternative approach I had considered was issuing an XLS with the project data every so often via email, and users copy & overwrite the existing file to the root of their documents folder, but that seemed to involve issues with Trusted Locations etc...
