Hi there,

I must say this is a great resource! I've found lots of useful information and got some much needed help with a problem yesterday.

I've run into a little problem... I think I'm probably treating it all wrong but who knows!

I'm wondering if there is a way to that when a option from a drop down list is selected (ie. YES/NO) it then remove that entire row from the spreadsheet and moves it to another worksheet. Is this possible?

My other problem is that I want to have some statistics and at the moment I have these at the top of my sheet however I'd ideally like them on a seperate sheet. 2 examples of the functions I'm using for statistics are
"=COUNTIF(A12:A400,"PEP")" and "=SUMPRODUCT((A12:A1000="PEP")*(J12:J1000="Yes"))" - Is there anyway to get excel to pull this from the other sheet?

Sorry if a lot of this sounds rather straight foward!