Basically I need to know if it is possible to make a macro that would copy the subject of an email from Outlook into cell B1 if the email address matches the email address in line A1.

I wouldn't need anyone to go in depth and create the whole thing, just asking if its something that is possible.

Theoretically if this is possible would I need to have that excel file open every time I send an email that I want to match up?