Hi, this is my first visit here, having used the site several times to help me get as far as I have so thanks everyone.
Due to having to work from home and having to justify my existence, I have had to try and learn VBA, macros etc and "upgrade" some of our worksheets we use at work, as such I am using Excel 365 and unable to install any 3rd party add ons.
I am currently working on upgrading the work leave planner. I have created a userform to capture all the required info - Name, Type of Leave and Start/End Dates and Comments required. Due to not having the date picker option, the dates are added manually (dd/mm/yyyy) in a textbox (one for start and one for end)
I have managed to export all the data from this form back into a separate sheet so all the info is there. However, what I need it to do it look at the name and date and complete the associated cell on the main planner with the type of leave required.
I have attached a sample workbook of a very basic version, the actual version has 50+ staff over different shift patterns with more leave types but the principles are the same.
To summarise, I need the worksheet to look at the name, date and leave type in "Sheet2", find the same name and date in "Sheet1" and complete the related cell with the leave type. Sheet 2 will continuously be populated via the userform so there may well be more entries added for the same staff member further down the sheet, not all in one place.
Hopefully that makes sense, any guidance would be much appreciated.
Bookmarks