I have an Excel spreadsheet that is used to track project time and leave for employees. This spreadsheet is designed to rollup to an Access database and provides the manager with reports. The Excel spreadsheets are standalone documents and the Access database resides on a server.
We use project codes to track our work. I need to be able to use a projectlist table from Access as a drop down list in an Excel spreadsheet. The list also needs to be updatable from within both Excel and Access as we create new project codes. I found documentation regarding bringing refreshable data from Access into Excel, but what I need is the option for the user to pick from the list (similar to an Access combo box).