Vlookup on fixed value

[Stanman]

Hi,

Is there anyway I can copy cells from one work book to another based on a value that does not exist in the copy from WB?

I have a large spreadsheet with date n one column and want to copy the data to new spreadsheets but pulled into indivdual WB based on the date.

I tried VLOOKUP and typing the date as the search but it didnt work