How to deal with this problem?

jjsanders

New Member
Joined
Oct 16, 2006
Messages
36
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!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
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

New Member
Joined
Oct 16, 2006
Messages
36
Ehhmm,

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

Forum statistics

Threads
1,136,878
Messages
5,678,315
Members
419,754
Latest member
LordEddard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top