VBA to extract data from another workbook based on multiple criteria

[ellieB]

Hello

I am new to VBA and trying to create a macro to pull data into a workbook set up as a calendar based on both a date column and "yes no" column in another workbook, is this possible?

Thank you,

 

[ranman256]

sure. you got data to build the macro with?

 

[ellieB]

Thank you!
My goal is to get the 'Name' , ' Location' and 'Job Title' to pull onto the side of the calendar sheet based on the 'orientation date' field on the "candidate offer to hire status" sheet