code to extract specific data into specific columns

Hi All,

I need some help here. I'll try to explain the best I can. I have two worksheets. In one I have a dump of data from emails (see sheet "Alerts"). I want to run a macro to extract the rows from Alerts that match the column headings in sheet "Tracking". Is this possible, and if so how?

Is there a better way to extract this information directly from outlook emails?

Thanks

Hi

This will work from the spreadsheet provided.

You probably could do this directly from outlook. There are quite a few examples with code to access outlook and manipulate the items there. Try searching and see what you can come up with.

Please Login or Register  to view this content.

rylo

Looks to work great! I'll just tweak a bit. Thank you very much.. I will search on accessing Outlook.. Thanks again!