help with Date summary

[gambi]

Hello
I have a problem.

I have one excell sheet where i have a bunch of names and dates listed
Ex:
A B C
1 Name Date Number
2 Mickel Ball 2008-09-01 123456
3 Anna Bell 2009-04-03 654321
4 ......
and so on

I Sheet 2 I whant to search Sheet 1 for all dates that are older than
todays date and then list them in Sheet 2. With names, date & number

If you have a good solution to my problem feel free to wright.

Och om du är svensk så våre det kanon om jag kunde få ett svar på
svenska.

BR

 

[?????]

I think Advanced Filter is enough to resolve this problem.


"gambi" <[email protected]>
??????:3bcfcb21-7801-4c88-b953-c29104e8272d@g23g2000vbr.googlegroups.com...
Hello
I have a problem.

I have one excell sheet where i have a bunch of names and dates listed
Ex:
A B C
1 Name Date Number
2 Mickel Ball 2008-09-01 123456
3 Anna Bell 2009-04-03 654321
4 ......
and so on

I Sheet 2 I whant to search Sheet 1 for all dates that are older than
todays date and then list them in Sheet 2. With names, date & number

If you have a good solution to my problem feel free to wright.

Och om du är svensk så våre det kanon om jag kunde få ett svar på
svenska.

BR