LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 110
Default Transfer specific clients.

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.

Example Based on Today's date 9/24/08
Sheet1 i have A: A200 Clients: and B: B200 Dates:

John Doe 4/28/08
John Doe 5/25/08
John Doe 6/1/08
John Doe 7/20/08
Chris Smith 1/1/ 08
Chris Smith 1/23/08
Dana Smith 6/22/ 08
Dana Smith 4/2/08


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

From the example above it should only be John Doe.. sice he came once last
4 months in a row from todays date., Chris and Dana has not.,

If iam not making sense or there isn't a possile formula please let me know.

Thankx in advance.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically Transfer Clients from last 4 months to another sheet Jman Excel Discussion (Misc queries) 0 September 24th 08 03:02 AM
How to Automatically transfer specific Data from Sheet 1 to Sheet Jman Excel Worksheet Functions 12 May 10th 07 05:35 AM
Form Information transfer to a specific record LT Excel Discussion (Misc queries) 1 March 6th 07 06:29 PM
14 Clients Michell Major Excel Discussion (Misc queries) 4 October 18th 06 12:28 PM
Match a name to all clients? Dixie Excel Worksheet Functions 3 April 30th 05 03:28 AM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"