Automatically copy data based on 2 criteria

Hey,

I'm very new to using VBA and macros, for the below I've been working with some code i found on Ron De Bruins site.

I have 2 sheets one called Campaign Status and one called Post Campaign Tracker. When someone changes a value in column H on the Campaign Status to "Done" or "Proactive Done" I want certain cells from that row to automatically populate the Post Campaign Tracker. The Post Campaign Tracker is essentially a summary sheet of all done campaigns. Each time this happens I want it to only add new rows to the bottom or clear the existing data and repaste.

I've attached a sample document with the main information. I want only cells A, C, D, G and K in each row to be copied over to the Post Campaign Tracker if "Done" or "Proactive Done" are selected in column H on the Campaign Status.

Ron's code that I've been working with is below:

Please Login or Register  to view this content.

To get this code to run automatically from the Campaign Status I've added in the below code to that sheet. It includes a datepicker and I can't seem to get the macro that makes the above run automatically to work with the datepicker.

Please Login or Register  to view this content.

Any help would be much appreciated, this is for my work.

Thanks

Oscar