Stock List

Hi

Im very new to Macros & VBA. I am a stock controller that receives stock requests by email. I want to be able to run a Macro or VBA so that it checks the items ordered column and if it has a figure in it, copy the whole item to another work sheet or a new area in the current worksheet so that I have a list to print out of only the items ordered. Im sure that this would be possible, anyone out there that can help me?

Hi

I had a reply from Bryan Hessey about this but his replay does not seem to appear here. Anyway he suggests using Auto Filter, I had already triid this but because of the way the form is made up (mot my doing) this does not work. Anymore ideas?

Many thanks

Hi again

I have found this thread which looks like it may help but I am not advanced enough to understand it all: http://www.excelforum.com/showthread.php?t=579921

I want to be able it to search say Column C for a figure greater than or equal to 1, then copy the whole row to a new worksheet, then continue the search until the whole sheet has been processed. The worksheet range is A9:E119.