I have created a form in Excel. I would like to know if it is possible for the information from the spreadsheet to be utilized on the form as though this Excel form was an Access form? In Access, the information I show in datasheet view is able to be used as a record and can be accessed on the form.
In my search over the last days, I have found how I can use the form as an easier way to key information into the spreadsheet format, however, I cannot figure out how to take that same spreadsheet information and put it in a form.
What I need to happen is for project managers to be able to go in to the form I have created and use the drop down box to select their projects and the rest of the information show up as it shows on the spreadsheet.
Is this possible? I am looking at each row in the spreadsheet being a record (like a datasheet in Access).
Help! I know we should be using Access, but this option has been shot down. So, if I am not explaining this in a manner that makes sense and able to generate help, please let me know and I will take another stab at it.
Thank you!
In my search over the last days, I have found how I can use the form as an easier way to key information into the spreadsheet format, however, I cannot figure out how to take that same spreadsheet information and put it in a form.
What I need to happen is for project managers to be able to go in to the form I have created and use the drop down box to select their projects and the rest of the information show up as it shows on the spreadsheet.
Is this possible? I am looking at each row in the spreadsheet being a record (like a datasheet in Access).
Help! I know we should be using Access, but this option has been shot down. So, if I am not explaining this in a manner that makes sense and able to generate help, please let me know and I will take another stab at it.
Thank you!