Adding date dropbox? Please?

[lincolnho]

So I figured out just about everything I need to for my project thanks you the MrExcel videos and forums.

However, I just have one last thing I need help with... Adding a dropbox for date selection showing 3 months of selected data based on the dropbox.

Anyone know how I can do this?

http://www.ecbchurch.org/english/excel/
The workbook.xlsm file is the one with the dashboard, which pull data from the other 4 files in this folder.

 

[Akashwani]

Hi, welcome to MrExcel.

If you could post some sample data of your sheet and the results you expect that would be helpful

Do you mean something like this?....

Excel Workbook
	A	B	C
1	Date	Name	Number
2	02/02/2011	Bill	111111
3	03/02/2011	Tom	111112
4	04/12/2011	Bob	111113
5	05/02/2011	Sue	111114
6	06/02/2011	Flo	111115
7	02/12/2011	Mo	111116
8	08/02/2011	Dan	111117
9	09/02/2011	Den	111118
10	02/02/2011	Jo	111119
11	11/12/2011	Joe	111120
12	12/02/2011	Tim	111121
13	13/02/2011	Ben	111122
14	02/12/2011	Fred	111123
15	15/12/2011	Stan	111124
16	16/12/2011	John	111125
17	17/02/2011	Jack	111126
Master

Excel Workbook
	A	B	C
1	From Date	End Date	Count
2	02/02/2011	03/05/2011	10
3	*	*	*
4	Date	Name	Number
5	02/02/2011	Bill	111111
6	03/02/2011	Tom	111112
7	05/02/2011	Sue	111114
8	06/02/2011	Flo	111115
9	08/02/2011	Dan	111117
10	09/02/2011	Den	111118
11	02/02/2011	Jo	111119
12	12/02/2011	Tim	111121
13	13/02/2011	Ben	111122
14	17/02/2011	Jack	111126
Lookup

The above returns all the data that falls between the 2 dates.

A2 has a dropdown list.
B2 is A2 + 90 days.
The formula In A5 needs entering with ctrl shift enter NOT enter.
You can then copy it across and down as far as you require.
Sheet names and cell ranges will need to be changed to suit yours.

I hope this points you in the right direction of the solution you seek.

Good luck.

Ak

 

[lincolnho]

I'd love to post a sample up or even a screen shot... I can't seem to post it up here like you did.

 

[lincolnho]

Hi Akashwani, could that thing you have work along with the other dropbox with what I have put down as my example?

 

[lincolnho]

Oh, this is exactly what I want to do: http://www.youtube.com/watch?v=JSfrpC6GL5w

Can you do this in Excel 2007?

 

[Akashwani]

Hi,

I believe you can only do that with Excel2010, slicers are not available before then.

Sorry that I couldn't be of more help to you.
You will find plenty of helpful videos at......

http://www.youtube.com/user/ExcelIsFun#g/u

Search for Tables or Drop down.

Good luck.

Ak