Macro to Filter & Extract Data to a New Workbook

Hi everyone,
I'm stuck here, trying to write a macro that would filter data out of active worksheet and extract it into a new workbook. Please view attached file for reference.

I need the macro to filter the data in Activesheet (which would be protected except for column C) and extract each row in which there's a record of items being sold (C<>B; D>0; F>0). The data in column C would be entered manually.

Also it would be nice if at the same time the macro could copy entire column C and paste it into column B on sheet Stock (which would be hidden) so that the Items Left would represent new amounts of Items in stock. Anyway. this second feature is not of a top priority

Thank you for your time, friends.

All of those rows from Activesheet in which there's a record in column C (and C does not equal B) i.e. I need a list of all items that were sold.

Originally Posted by snb

You can use autofilter or advancedfilter.

That doesn't help at all since the workbook will be used by people who don't do copy&paste let alone advanced filter.

Easy enough, mate