Hi Everyone! Sorry if the title doesn't make sense, I couldn't think of another way of describing what I am trying to achieve here. Currently, I am trying to create a UserForm which shall be used to log workers hours. I have a working copy, however when the user clicks save, the data is added to the next line within my data tab. As a result, If the user is entering workers hours for last week, the data will be inserted at the bottom of the list within the data tab.
Preferably, I would like the data to input into a certain location within the sheet dependent on what date is selected. For an example of this, please see the picture below.
https://imgur.com/Go76TCo
As you can see here, this was the previous version of this sheet I was using. The column states what the date is and the row is for each worker. With this user form, I would ideally like it to detect the date and fill in the corresponding cells. E.g. if 29-Sep-18 was selected, the form shall populate the data into column 958. If 30-Sep-18 was selected, the data would populate into column 968.
I hope this makes sense and thanks in advance for any help.
Preferably, I would like the data to input into a certain location within the sheet dependent on what date is selected. For an example of this, please see the picture below.
https://imgur.com/Go76TCo
As you can see here, this was the previous version of this sheet I was using. The column states what the date is and the row is for each worker. With this user form, I would ideally like it to detect the date and fill in the corresponding cells. E.g. if 29-Sep-18 was selected, the form shall populate the data into column 958. If 30-Sep-18 was selected, the data would populate into column 968.
I hope this makes sense and thanks in advance for any help.
