01-27-2009, 08:38 PM
|
#11
|
Kicking up my heels!
Join Date: Jan 2005
Location: The Silver State
Posts: 3,783
|
Quote:
Originally Posted by Drince88
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!)
|
That's a great trick!
__________________
Nee Stell Thue
|
|
Submit to Quotes
|