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.