Hi, I hope someone can help with this or tell me if it is even possible, I have a workbook that logs holidays and has a sheet for each month eg January / February etc and laid out like below, I have a userform with a dropdown box with all the names, I would like to select a name from that list and press a button which searches through all the sheets January to December and finds the row that matches the name eg in the below say John (row 3) then find anything with a H in it and then return the date in row 1 and so on. so i would end up with a list of all the dates for john in a seperate sheet so in the example below i would end up with 03/01/21 and 06/01/21
Hope that makes sense and any help would be appreicated
Trev
Hope that makes sense and any help would be appreicated
Trev