Hi all,

This looks to me to be a really complicated thing to do but maybe it's not.

I have two workbooks with essentially the same info EXCEPT for a couple items.
WB1
short file name, file size, date, time, file owner
WB2
full file name, file size, date, time

I tried sorting by date, time, size, name but unfortunately the lists are
not exactly the same.

So....
How complicated is it to have Excel compare the date, then the time, then
the file size between and if these match paste the full file name from WB2
into the WB1 in the row where the match occurs.

Sound easy? Here's some of the data...
WB1
WORLEST.WPD 8,060 5/3/1999 2:50p MTS
SMSPRO~1.CV5 126,220 5/4/1999 3:42p RJS
ASPHAL~1.CNV 134,134 5/7/1999 2:38p SMS
PLANMS.MCR 55,200 5/10/1999 10:34a MTS


WB2
2:50p 5/3/1999 8,060 WORLEST.WPD
3:42p 5/4/1999 126,220 SMS Prov and Stew.cv5
2:38p 5/7/1999 134,134 Asphalt trail.cnv
10:34a 5/10/1999 55,200 PLANMS.MCR

Result
2:50p 5/3/1999 8,060 WORLEST.WPD MTS
3:42p 5/4/1999 126,220 SMS Prov and Stew.cv5 RJS
2:38p 5/7/1999 134,134 Asphalt trail.cnv SMS
10:34a 5/10/1999 55,200 PLANMS.MCR MTS

Thanks in advance
Toney