Show specific rows and colums on dropdown list selection

Hi,
I am trying to show specific set of rows and columns based on selection of dropdown list. For eg., If I have 1,2,3,etc., on my dropdown. When I select number 1, it should display A1:C5 (5 Rows and 3 Columns) down below my dropdown. When I select number 2, it should display A6:C11 (6 Rows and 3 Columns) down below my dropdown list. Can someone help me??

Thanks in advance.

The only way to do it, as far as I know, is to do it with programming. You will have to read that cell with the dropdown list in your SheetChange event/routine and then programmatically hide/unhide prespecified columns and rows based on that cells value. Have you done macros before?

Can you explain in more detail what you wish to accomplish, maybe attach an examples or 2 of what the rows and columns typically will be.

Cells A1-A5 are named as Fruits, A6-A10 as vegetables, A11-A15 as cookies
B1-B15 are some values corresponding to fruits, vegetables and cookies
Similarly C1-C15 are some other values corresponding to cell B1-B15

We assign dropdown in different column, say for eg. G1 cell
When we select fruits in dropdown, it should list A1-A5, B1-B5 and C1-C5 down below dropdown ie (Cells F2-F6 used to display A1-A5, G2-G6 used for B1-B5 and H2-H6 for C1-C5)
When we select vegetables, it should list A6-A10 on same F2-F6, B6-B10 on G2-G6 and C6-C10 on H2-H6

I hope you get a better idea now..
Thanks...

Sound to me all you need is to apply filtering?

Yes, could you please design a excel and show me how to work..??

View this tutorial: http://www.free-training-tutorial.co...er-basics.html