Validating data before copying Row

[f3racer]

I am having an issue with validating data in 2 columns before a row copy is performed.

The other issue I am trying to get working, is being able to combine several of these statements to validate other data into separate sheets.

So in the example below I am looking to have the data that is equal to 22 + Mail Box, that row would be copied to Sheet Product.

Then I am looking to have the data that is = to 289 + Mail Box that row copied to sheet Supply.

Here is the issues I am running into:
When I run the script it pulls into Sheet Product everything with 22 in column D regardless of the Mail Box string.

Also I am not able to pull any data into the supply sheet.
So if in Column D = 289 and Column E = Mail Box then copy row to Supply.

So What am I missing here??
Any help is greatly appreciated.

Thank you.

Jim
Here is a small scale of the script I am trying to get working:

Please Login or Register  to view this content.

Here is the data in the spreadsheet:

Product ID Product Name Unit Price Units In Stock Description
1 Filet Mignons 18.00 39 Mail Box
2 Chang 19.00 23 Mail Box
3 Aniseed Syrup 10.00 13 Mail Box
4 Chef Anton's Cajun Seasoning 22.00 53 Mail Box
5 Chef Anton's Gumbo Mix 21.35 289 Mail Box
8 Northwoods Cranberry Sauce 40.00 6 Mail Box
9 Mishi Kobe Niku 97.00 23 Mail Box
10 Ikura 31.00 31 Mail Box
11 Queso Cabrales 21.00 22 Mail Box
12 Queso Manchego La Pastora 38.00 86 Mail Box
13 Test mailbox 12.00 289 Mail Box
14 testing 44.00 22 Anything

[f3racer]

sorry just trying to increase my odds of getting an answer to my question.

I have asked this same question on MrExcel http://www.mrexcel.com/forum/showthread.php?t=374081

Thanks,

Jim