G
Guest
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.
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.