Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying data from seperate sheet upon drop down box entry
I have nearly 20 sheets of data all different values of columns and rows and
would like to create in the first empty sheet a search menu. I would like this first sheet to be capable of displaying data from another sheet by selecting the sheet name, rows, and columns from drop down menues. Ex. Sheet "A" has 4 columns and 40 rows. The first 20 rows belong to one set and the second 20 rows belong to another. I'd like to use the first sheet named "Search" to display all the data in sheet "A" belonging to the first set (first 20rows and 4 columns) by simply selecting Sheet = A Columns = 1-4 Rows = 1-20 These selected from drop down menues. Is this possible? No calculations are needed i simply need a way to call up data easier than searching through each seperate tab. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying data from seperate sheet upon drop down box entry
I would make 5 different dropdowns, one for the sheet, and two for each
range. With that, you can create a column header (let's say row 2) that goes from the starting column to the ending column (values 1, 2, 3 and 4), a row header (column A) that does the same with the rows. Let's say that the sheet dropdown with the sheet name is in A1, you can use the following formula inside this "table" (this is for cell B3) =INDIRECT($A$1 & "!" & ADDRESS($A3,B$2)) Hope this helps, Miguel. "keeper" wrote: I have nearly 20 sheets of data all different values of columns and rows and would like to create in the first empty sheet a search menu. I would like this first sheet to be capable of displaying data from another sheet by selecting the sheet name, rows, and columns from drop down menues. Ex. Sheet "A" has 4 columns and 40 rows. The first 20 rows belong to one set and the second 20 rows belong to another. I'd like to use the first sheet named "Search" to display all the data in sheet "A" belonging to the first set (first 20rows and 4 columns) by simply selecting Sheet = A Columns = 1-4 Rows = 1-20 These selected from drop down menues. Is this possible? No calculations are needed i simply need a way to call up data easier than searching through each seperate tab. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create drop down lists in Excel for correct data entry | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Data Entry With Drop down Keypad | Excel Discussion (Misc queries) | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions |