Hello all,
I have challenge. I need to have a few dropdown menus in Excel 2000 (Im
working in Excel 2007).
My data is in columns A-G. Columns A-C have the duplication information:
A=Deposit Date, B=Check# and C=Check Amount. E-G do not have duplication
information: E=Ref#, F=Amount, and G=Text or message field.
I need to have one dropdown menu list the Deposit dates, but only one date
not all the range of data, i.e. if 12/12/08 is list 5 times, I just need the
one date. Dropdown menu would have the following: 12/1/08, 12/02/08, 12/03/08
ect. if listed.
With that dropdown menu, if 12/03/08 is select, it will bring back a drop
down menu with the check #s and amount.
And finally, If check 1234 is selected, in cell A2-C2 it will display the
Ref#, amount and text just for that check.
Can this be done?

Thanks in advance.

It sounds like you simply need to apply a filter. Highlight your header row,
then go to datafilterautofilter.

"pgarcia" wrote:

Hello all,
I have challenge. I need to have a few dropdown menus in Excel 2000 (Im
working in Excel 2007).
My data is in columns A-G. Columns A-C have the duplication information:
A=Deposit Date, B=Check# and C=Check Amount. E-G do not have duplication
information: E=Ref#, F=Amount, and G=Text or message field.
I need to have one dropdown menu list the Deposit dates, but only one date
not all the range of data, i.e. if 12/12/08 is list 5 times, I just need the
one date. Dropdown menu would have the following: 12/1/08, 12/02/08, 12/03/08
ect. if listed.
With that dropdown menu, if 12/03/08 is select, it will bring back a drop
down menu with the check #s and amount.
And finally, If check 1234 is selected, in cell A2-C2 it will display the
Ref#, amount and text just for that check.
Can this be done?

Thanks in advance.