Reference other sheet

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
Back
Top