How to deal with this problem?

[jjsanders]

Dear all,

I want to describe to you my situation. Wat i want to ask is the best possible way to deal with my situation in Excel.
We are currently testing some new software. Therefore we have sheets to control the status of the testing.
I have two sheets in my workbook:

1. sheet one is an overview of al my tests. It gives general information about the test.
2. This is I detail sheet. For each test i need to fill out a form with the details.

Now we have about 166 tests to do so far. According to my opinion it's not good to make a new sheet for each test because then i will loose overview.
I thought of dumping a detailsheet for each testcase in a word document and put a link in my overview sheet. But i am not sure if this is the best way to do it. Matbe you have other opinions of how to deal with this????


Thanks in advance!

 

[agihcam]

Hi -
you can do also those details in a separate sheets and retain the overview on the first sheet. all you need to do is set up the sheets so that when a certain click on particular test it will goes to corresponding detail sheet.see help for hyperlink function. is that make sense?

 

[jjsanders]

Ehhmm,

I think that then my excel document will become too big. It will be enough i think to save them in seperate files.