View Single Post
Old 01-27-2009, 07:20 PM   #20
Drince88
Senior Member
 
Drince88's Avatar
 
Join Date: May 2005
Posts: 481
Drince88 is swinging to this padDrince88 is swinging to this padDrince88 is swinging to this padDrince88 is swinging to this padDrince88 is swinging to this padDrince88 is swinging to this padDrince88 is swinging to this padDrince88 is swinging to this padDrince88 is swinging to this pad
For the second part - highlight ALL the tabs you want to make a change in (use the shift or control key) - it'll say [Group] at the top next to the workbook name. And then on the first tab, change the equation in the cell, and it should change it in all of them. I just tested it and it worked.

The BIG thing on this, though - is to un-group the tabs before you go and do more work - otherwise you run the risk of making changes to every sheet, that you didn't really mean to (not that I PERSONALLY have ever done anything like that - nope, not me!)
Drince88 is offline   Submit to Quotes Reply With Quote