VBA code to create summary sheet

Hey all,

I'm very new to macros, but need to create one to automatically copy over certain cells from rows to another sheet when a criteria in that row is met.

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.

See if this does what you want.

Hey John, thanks for the help works like a treat!!

Is there a way of making it so that if the Status then changes from Done or Proactive - Done back to something else that it gets removed from the Post Campaign Tracker sheet?

Thanks
Oscar

See if this works for you.

Works an absolute charm, thanks so much for your help John!!

Thanks
Oscar

You're welcome. Glad to help out and thanks for the feedback. Please refer too the rules link below and mark this thread as SOLVED.

http://www.excelforum.com/forum-rule...rum-rules.html