If then copy to
 

Here is my issue, I have a very large workbook with lots of columns and rows
in lots of worksheets. I need one of the worksheets to search the data in two
columns that meet specific criteria and copy those cells into a blank column.
Something like this:

if date in column a is = today's day minus 5 years and name in column b=joe,
sally or james, move cells to column c

Any suggestions out there?

Thank You,
--
maggiesteele

If then copy to
 

Hi,
You really need a macro to do this. If you need help writing it, you'd have
to supply some more detail. ie.
Sheet names.
Cell References of all data you wanted sorted.
Cell References for the destination of the sorted data.

Also, the date criteria: do you really mean Today minus 5 years (ie
16-May-2003 only) or do you mean any date less than 5 years old?

Regards - Dave.