ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automatically Transfer Clients from last 4 months to another sheet (https://www.excelbanter.com/excel-discussion-misc-queries/203653-automatically-transfer-clients-last-4-months-another-sheet.html)

Jman

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.















All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com