Automatically Transfer Clients from last 4 months to another sheet

J

Jman

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top