View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jman Jman is offline
external usenet poster
 
Posts: 110
Default Automatically Transfer Clients from last 4 months to another sheet

I want to Automatically transfer Clients from sheet1 to sheet 2. I only want
clients that have come for the last 4 months in a row only ONCE a month,
from todays date. . I also want it to autoupdate itself as the current month
passes.


Sheet1 i have
A: A200 Clients:
John Doe
Josh Curtain
Justin Jamell
etc..

B: B200 Dates:
2-25-08
2-28-08
3-11-08

Sheet 2
In Column A down. i want the names only to be trasfered.