Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |