I have multiple sheets (15) which store marks and calculate totals, with one sheet per class. The formulae in each sheet are identical. I would like to be able to change the formulae in the first sheet and have the rest of the sheets update accordingly. In essence, simulate copying the formulae from sheet 1 to the other 14 (copy/paste for every tiny change gets old).
A unrelated issue: Is there a way to save conditional formatting written in Excel 2007 to work with Excel 2003? There are three rules and their formats are supported by 2003. When I open the workbook with 2003, only the first rule remains.
Many thanks to anyone taking the time to read this!
Mint
Hi and welcome to the board.
It's always best to create one thread per question so that everybody can profit from the answers.
Have a look at forum rules
As for your first question, do you mean that in the same cell in each sheet you need the same formula?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Thanks for you prompt reply! Sorry for posting two questions, the first is much more important than the second (an afterthought really) so I'll be happy just to get a solution to the first for the time being.
Yes, the formula in each cell should be the same for every sheet, so that the calculation is the same for each class, exactly as it would be if I copied the ranges of cells containing formulae from the first sheet to the same ranges of the other sheets.
Ok
in this case try this :
Select the first sheet tab
Press and hold down the Shift key
Select the last sheet's tab
Enter the formula where needed
When you're done right-click any tab and select " ungroup sheets"
HTH
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
How interesting, totally different approach to what I was expecting but it works really well. I swear no matter how much you use Excel there's always something you've never see before haha. Many thanks.
Glad to help and thank you for the feedback
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks