>Yah there is a little more to it. See Attachment for details about how
>the dates show up in the drop down menu.
[quoted text clipped - 3 lines]
>|Download: http://www.excelforum.com/attachment.php?postid=4958 |
>+-------------------------------------------------------------------+
Sorry. Here is the same thing again. // Stands for the bring down
function.
Date // Account // Price // Department //
6/12/2006 B3433 487.99 Frank
6/13/2006 B3433 432.99 Gregory
6/14/2006 C2354 325.34 Frank
6/23/2006 C2322 3423.23 Frank
7/12/2006 B3433 43.33 Harvy
7/23/2006 B3433 4335.32 Tammy
8/23/2006 C2342 324.34 Harvy
Date has bring down box that says:
(All)
(Top 10)
(Custom)
6/12/2006
6/13/2006
6/14/2006
6/23/2006
7/12/2006
7/23/2006
8/23/2006
I want it to say:
(All)
(Top 10)
(Custom)
June
July
August
With the same dates still in the table like now.

Signature
rbrickl
Gord Dibben - 29 Jun 2006 22:42 GMT
From your description, it seems you did not create the drop-down menu, you
simply have Autofilter turned on.
Autofilter list will show exactly what is in the cells.
You cannot change this AFAIK
You can use the Custom to extract only the month you wish to see.
Gord
>Sorry. Here is the same thing again. // Stands for the bring down
>function.
[quoted text clipped - 32 lines]
>
>With the same dates still in the table like now.
Roger Govier - 29 Jun 2006 22:51 GMT
Hi
I think the only way to achieve what you want would be to insert a new
column A.
In cell A2 enter =B2 and Format>Cell>Number>Custom>mmm
Copy down column A for the extent of your data.
Extend your Autofilter range to include the newly inserted column A.
Use the dropdown on column A to Select the Month required.

Signature
Regards
Roger Govier
> Sorry. Here is the same thing again. // Stands for the bring down
> function.
[quoted text clipped - 32 lines]
>
> With the same dates still in the table like now.
rbrickl - 30 Jun 2006 14:34 GMT
Am I in the right forum or not. I think I should go to a more exper
one. Anyways will someone please help me with my delema
rbrickl - 30 Jun 2006 14:40 GMT
Am I in the right forum or not. I think I should go to a more expert
one. Anyways will someone please help me with my delema.

Signature
rbrickl
Roger Govier - 30 Jun 2006 23:09 GMT
> Am I in the right forum or not. I think I should go to a more expert
> one.
Fine
Just because you don't like the answers you have been given, doesn't
mean they are incorrect.
Have fun elsewhere.

Signature
Regards
Roger Govier
> Am I in the right forum or not. I think I should go to a more expert
> one. Anyways will someone please help me with my delema.
Gord Dibben - 01 Jul 2006 00:30 GMT
I think you should go to a more expert forum.
Changing what you see in the drop-downs of Autofilter is beyond us.
Gord
>> Am I in the right forum or not. I think I should go to a more expert
>> one.
[quoted text clipped - 4 lines]
>mean they are incorrect.
>Have fun elsewhere.