[Dba-office] Referencing previous sheet in Excel

 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;
...


-- Shamil

Sun, 21 Dec 2014 12:41:26 -0500 from Susan Harkins <ssharkins at gmail.com>:
>Does anyone know of a formula that can reference the previous sheet,
>regardless of the sheet's name? I've found several uses of Indirect(), but
>they rely on the sheet names being labels somewhere else and that actually
>complicates things. In this case, I have a fixed number of sheets --
>January through December. It's just as easy to reference each sheet by name
>as it is to create a table of names somewhere. What would be beneficial and
>simpler is a single formula that can reference the same cell in the
>previous sheet, regardless of the sheet it's in.
>
>February: 'January'!B2
>March: 'February'!B2
>April: 'March'!B2
>
>and so on...
>
>If I could use the same formula in each sheet, it would be simpler.
>
>Susan H.
>_______________________________________________
>Dba-office mailing list
>Dba-office at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-office