generating report table from database

[KOY]

Thanks in advance to anyone that can help me.

I have a worksheet with investment information. Basically, I am invested in funds who have their own investments (sub-investment) and my spreadsheet lists all the sub-investments that I have (along with information about them) and in another column tells me which of my funds holds the particular investment

On another worksheet I have created a dropdown box at the top of the sheet with a list of every fund name. I am trying to get it so that when I select a fund name, all the investments of that fund are returned below.

Thanks,
KOY

 

[Yahya]

welcome to MrExcel Board
see if this idea will help you
first sheet hold your data

Excel Workbook
	A	B
1	Fund	Aboumt
2	Fund A	2030
3	Fund B	1971
4	Fund C	4689
5	Fund D	2005
6	Fund A	4319
7	Fund B	3139
8	Fund C	2084
9	Fund D	3173
10	Fund A	5231
11	Fund B	1997
12	Fund C	2861
13	Fund D	4872
14	Fund A	5355
15	Fund B	2237
16	Fund C	2248
17	Fund D	4750
18	Fund A	2668
19	Fund B	3384
20	Fund C	5515
Sheet1

Excel 2007


Next sheet

Excel Workbook
	A	B
1	Fund Name	Fund A
2
3	Fund	Aboumt
4	Fund A	2030
5	Fund A	4319
6	Fund A	5231
7	Fund A	5355
8	Fund A	2668
9
Sheet2

Excel 2007

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

HTH