Just some more information.

In last weeks worksheet, I have two columns (among others) that contain a
workorder and a date.

Trav BP Week
H623601 11/7/05
H623619 11/7/05
H815003 11/7/05
H815011 11/7/05

This week, I have just the workorder and would like to add the dates through
VBA

Trav BP Week
H815003
H815011
J456809
J456787

Suggestions would be appreciated.




"Byron" wrote:

I have a worksheet that has work orders and build dates from last week
(occurs weekly by hand presently). I would like to transfer the dates to the
new worksheet in a new workbook for those work orders that are still present.
I have been using a VLOOKUP, is there a way to do this, line by line in VBA?

Thanks.