Reference other sheet

[Jeff]

I have a sheet (Study Sheet) that has from 1 to 10 Studies across and 1 to 30
Cases down.
Study 1 Study 2
Part Test Results Part Test Results
Case 1 1 Case 1 1
2 2
3 3
4 4

Part Test Results Part Test Results
Case 2 1 Case 2 1
2 2
3 3
4 4



On a separate work sheet I would like to have a place at the top that I
could change the case number and the study number and it would show the date
for just that case and study. This way they would not have to look at all of
them and get confused.
Case #
Study #
Study 2
Part Test Results
Case 2 1
2
3
4

Also can I modify the data and have it reflect on the Study Sheet?
Thanks! Jeff

 

[Max]

Jeff, guess this is answered in your other posting in .misc, re:
http://tinyurl.com/ypf4jj

---