Hi I am hoping some one can once again help me with an issue.
I have a spreadsheet which has sheets named Jan feb etc and in each sheet I have the dates of the month going across in the columns and names of employees in the rows like below.
what I want to do is create a userform where the user can select the employee from dropdown along with the sheet name / type of holiday or absence again from a dropdown and they then enter a start date and end date for the holiday requested and then click an update button to populate that data on the corresponding sheet.
Example : if I selected 04/1/21 to the 07/1/21 in January for employee 12345 for HOL it would fill in cells H4 to K4 with HOL in each.
Is this possible? and can some one please help or point me in the right direction
thanks for any help in advance
I have a spreadsheet which has sheets named Jan feb etc and in each sheet I have the dates of the month going across in the columns and names of employees in the rows like below.
what I want to do is create a userform where the user can select the employee from dropdown along with the sheet name / type of holiday or absence again from a dropdown and they then enter a start date and end date for the holiday requested and then click an update button to populate that data on the corresponding sheet.
Example : if I selected 04/1/21 to the 07/1/21 in January for employee 12345 for HOL it would fill in cells H4 to K4 with HOL in each.
Is this possible? and can some one please help or point me in the right direction
thanks for any help in advance
