Thread: Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sharmashanu sharmashanu is offline
external usenet poster
  
Posts: 28
Default Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet.
hey
use this formula

=IF((Sheet1!A1-TODAY())<=7, Sheet1!A1, "")

drag this down. but his will bring empty cells. but will copy all the
cells with date less than 7 days. Tell me if it works.

Reply With QuoteReply With Quote