Hello,

I am trying to figure out how to write a Macro/VBA script that will allow me to pull the highlighted information out of this workbook and automatically create an Outlook calendar event for the month entered into "Aprox Srv Mnth". I would also like to pull anything filled out in column "B", "C" and/or "K", "L".

This marco/VBA script is something that I am hoping to be able to run in any work book that I open. I've searched far and wide and have yet to find a suitable solution.


Thank you to anyone who might be able to help me tackle this macro!
Book1SampleTest1.xlsx