Quote:
|
Originally Posted by Plooshiska
Let's see if I can be specific... I have a "data" sheet, where I input the data by team number. Then I have an "interface" sheet, where I want to be able to type in a team number and have the data on that team from the "data" sheet appear.
|
Here is one example on how to do that:
http://www.chiefdelphi.com/forums/pa...le&paperid=487 Karthik used the OFFSET and MATCH functions.
Autofilter works great as long as you only displaying the data. I haven't figured out how to do calculations on the just the autofiltered data, though.