Keeping multiple sheets consistent in a workbook

I dont know if this is possible.

Basically, I keep track of test cases using Excel. I have multiple
sheets that have the same exact test case names (for alpha, beta, etc).

The problem is that if I add a new test case to one sheet, I have to add
it to all sheets. This is painful. What I would like is for the other
sheets to update automagically.

Is this possible? In other words, I am adding test case Z to sheet 1.
Can test case Z now show up on sheets 2, 3, 4, and 5?

Thanks.

-dmp

Select all your sheets. Make a change to one of them and they all change.

"Dave" wrote
> I dont know if this is possible.
>
> Basically, I keep track of test cases using Excel. I have multiple
> sheets that have the same exact test case names (for alpha, beta, etc).
>
> The problem is that if I add a new test case to one sheet, I have to add
> it to all sheets. This is painful. What I would like is for the other
> sheets to update automagically.
>
> Is this possible? In other words, I am adding test case Z to sheet 1.
> Can test case Z now show up on sheets 2, 3, 4, and 5?
>
> Thanks.
>
> -dmp

Dave,

Use either Ctrl or Shift as you click to select additional sheets. Any
change you make to one is made to all. The changes are made to the same
cells.

Depending on what you'll be doing with this data, you might want to put all
the stuff in one sheet, with an additional column for Alpha, Beta, etc.
Before you go too much further, read more at
http://www.smokeylake.com/excel/excel_truths.htm. "Data across multiple
sheets."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave" <dpowers@speakeasy.net> wrote in message
news:y5udnQIRsM9zfqjfRVn-vQ@speakeasy.net...
>I dont know if this is possible.
>
> Basically, I keep track of test cases using Excel. I have multiple sheets
> that have the same exact test case names (for alpha, beta, etc).
>
> The problem is that if I add a new test case to one sheet, I have to add
> it to all sheets. This is painful. What I would like is for the other
> sheets to update automagically.
>
> Is this possible? In other words, I am adding test case Z to sheet 1. Can
> test case Z now show up on sheets 2, 3, 4, and 5?
>
> Thanks.
>
> -dmp