Userform holiday input

trev1234

New Member
Joined
Mar 13, 2021
Messages
11
Office Version
  1. 365
Platform
  1. Windows
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

1616533882228.png



thanks for any help in advance
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,143,637
Messages
5,719,969
Members
422,252
Latest member
wannabegeek1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top