I am green on VB and currently I am using Mr. Ron de Bruin's getdata macro to
copy data from closed workbooks. What I am attempting to do is, as I am
getting the data, I need to question the content and depending on some
criteria continue to copy or go to the next record.

ex: A B C D
1 ron 01/01/07 (empty cell) process
2 bill (empty cell) (empty cell) started
3 mike 01/01/07 03/01/07 done
4 jon 01/02/07 (empty cell) started

if(b1<(now()),if(d1<"done"),"copy the record","get next record"),"copy the
record")

Thank you