Can I Ask For Help Creating A VBA Code Please

[pure vito]

Good Morning/Afternoon/Evening Experts,

As the title suggests I'd be very grateful if someone amongst you would be able to assist in creating a VBA code,

Here is what I am trying to achieve, Looking at Sheet "JobRequirements" Column B "License Requirements" I need to see who has this license in Sheet "People" for example column C has the names of the individuals and in the case of Reach Truck column Z has the answer Yes or No, so I need the list of names that have the License specified in "JobRequirements" Column B, and then we move onto Sheet "BIW" we need to look at the individual's that have the License and see if they are available for the date in "JobRequirements" Column D in "BIW" we need to see that on this date the cell's are blank that will tell us the individual's are free on the date,

I have user form's in this document I'm just not sure how this answer will be displayed within the document,

I have added a dropbox link with the document and I would really appreciate the help, thanks in advance.

Launch Holiday Tracker 2023 V1.2.xlsm

 

[hajiali]

Where in sheet BIW do you need the names to populate?

 

[pure vito]

Hi Hajiali, I’d like to display the answer in a list box so I think it needs to be separate I’d say anywhere in sheet 4 would be great and thanks for the response it’s much appreciated

 

[pure vito]

Also the names would not be the same if that helps