Hi All,
I am needing a bit of help on an Excel project that I am trying to create for my workplace - Its basically a log for any problems to be entered onto using a userform and then once submitted is stored on a hidden table which i then pick up once a week and work on - The inputting part works absolutely fine and all the information from the userform goes onto the table well.
The main thing i seem to be struggling with (spent nearly 2 days trying to work it out!) is how I can recall the information back onto the userform from the table so that it can be amended at a later date. I have also created a sequential numbering system (Ticket ID) when the user inputs the log and have a dropdown section which then shows these.
I ideally want to be able to select the Ticket ID from the dropdown and to then be able to recall the data back onto the userform from the hidden table so that I can edit and save.
Sorry if a bit vague, very new to excel but really struggling here!
Thanks in advance
EDIT:
Please let me know if there is a way of being able to upload the excel file on here? Or more than happy to send to someone to have a look at if possible?
I am needing a bit of help on an Excel project that I am trying to create for my workplace - Its basically a log for any problems to be entered onto using a userform and then once submitted is stored on a hidden table which i then pick up once a week and work on - The inputting part works absolutely fine and all the information from the userform goes onto the table well.
The main thing i seem to be struggling with (spent nearly 2 days trying to work it out!) is how I can recall the information back onto the userform from the table so that it can be amended at a later date. I have also created a sequential numbering system (Ticket ID) when the user inputs the log and have a dropdown section which then shows these.
I ideally want to be able to select the Ticket ID from the dropdown and to then be able to recall the data back onto the userform from the hidden table so that I can edit and save.
Sorry if a bit vague, very new to excel but really struggling here!
Thanks in advance
EDIT:
Please let me know if there is a way of being able to upload the excel file on here? Or more than happy to send to someone to have a look at if possible?
Last edited by a moderator: