Thread: If then copy to
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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.