Susan Harkins
ssharkins at gmail.com
Sun Dec 21 13:15:51 CST 2014
It took me a minute -- but I see what you're doing. You're right, I think that would work, but if I'm going to give each total cell a name, I might as well refer to it directly. I don't see that this simplifies anything in my example, but I think it has potential -- it's certainly interesting! Thanks! Susan H. On Sun, Dec 21, 2014 at 2:00 PM, Salakhetdinov Shamil <mcp2004 at mail.ru> wrote: > Susan -- > > I suppose to solve your task you can set a Scope for a Name. Let's say > your sample B2 cell names are keeping Month Total Sum values. Then you can > define the same name, let's call it 'MonthTotalSum' for your [January], > [February], [March] worksheets and for: > > - [January] worksheet set 'MonthTotalSum' name's scope to [February] > worksheet; > - [February] worksheet set 'MonthTotalSum' name's scope to [March] > worksheet; > - [March] worksheet set 'MonthTotalSum' name's scope to [April] worksheet' > ... > > And when you'll reference > > - MonthTotalSum name in your formula in [February] worksheet you'll > actually reference 'January'!B2; > - MonthTotalSum name in your formula in [March] worksheet you'll actually > reference 'February'!B2; > - MonthTotalSum name in your formula in [April] worksheet you'll actually > reference 'April'!B2; > ... > >