Copy matching lines

I have 2 workbooks, Ill call them wb1 and wb2.

I have two worksheets, call them w1 and w2.
On w1 I have on Row 1 my column titles like this:

CUSTID | NAME | WORK DONE | DATE | PRICE | DONE? |

On w2 I have in cell H10 a cell where a CUSTID will be typed. I also have on Row 17 column titles like this:
(a thru e column) (f thru h) (I)

WORK PERFORMED | DATE | PRICE |

When a Customer ID is typed into cell H10 on w2, I want all rows with matching CUSTID's on w1 to be placed, starting on Row 18 on w2. I only need the info from column C, D, and E copied over.

Anyone have any ideas?

The sample .xls is here: http://www.ashleylandscaping.com/sample.xls

or

Im not too swift with VB but heres what I have so far:

Please Login or Register  to view this content.

I edited the post to be more desciptive, hope it helps.