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!
Bookmarks