Copy Dates

**adsm** · 07-25-2010, 05:30 AM

Hi,

I’m trying to figure out a code that would copy the dates from column “F” of the sheet “Requests” and paste them to each row that matches with the serial number in the column “A” of the sheet “Orders”.

Any help on this would be kindly appreciated.

I’ve attached the workbook for your reference.

**martindwilson** · 07-25-2010, 08:13 AM

in A5 of orders
=VLOOKUP(B5,Requests!$B$4:$F$1500,5,FALSE)

**adsm** · 07-25-2010, 08:56 AM

Thanks for the help & I do really appreciate it.

**queryak** · 07-25-2010, 08:56 AM

Here is the formula which you can use to paste the date to each row that matches with the serial number in the column “A” of the sheet “Orders”.

Paste the following formula in cell A5 in "Orders" and drag it down.

=VLOOKUP(B5,Requests!$B$3:$F$1244,5,0)

Let me know if you face any problem.