Copy Selected Cells of Rows to another Worksheet Based on a Condition

First off, thank you for what you do! I am self-taught (arguably by a pretty shoddy teacher), and am determined to figure *some* of this stuff out. I've come to this forum many many times to work through issues with great success. Thanks!

I need a code to look at the rows on one worksheet and based on the value of column A for each row, copy cells A through E in that row to cells A through E of a blank row on a corresponding worksheet.

I found a code from another post that does just what I need it to with one small exception. The code was posted by DaveGuggs and is as follows:

Please Login or Register  to view this content.

I have modified the code above to fit my workbook. It works great and is WAY simpler than the code I had clunked out. I need to make one small change- in the code where it copies and pastes the data to the new sheet, I would like to only copy the data in column A through E, not the entire row.

I tried a bunch of things, for example, in this row of code

Please Login or Register  to view this content.

I put in

Please Login or Register  to view this content.

in place of

Please Login or Register  to view this content.

But it returned an error 13, type mismatch. What do I need to put in to only copy columns A through E of row I?

I'm sure this has a simple fix, and I'm sure that my question exposes my lack of vba intellegence. ; )

Thank you much!

Al

Like so:

Please Login or Register  to view this content.