Keeping multiple sheets consistent in a workbook

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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