Counting across tabs

[Tweeg]

Hey all,

I got like 50 tabs or so. And i would like tab2 to automaticly take
the value of a cell in tab1+1. And so on.

So a cell in tab3 should be: cella1 tab2 +1 (for example)

but how can i do this without having to change the formula on every
tab ?

Is there some formula that just does: previoustab cella1 + 1 ?

 

[Héctor Miguel]

hi, !

I got like 50 tabs or so. And i would like tab2 to automaticly take the value of a cell in tab1+1. And so on.
So a cell in tab3 should be: cella1 tab2 +1 (for example)
but how can i do this without having to change the formula on every tab ?
Is there some formula that just does: previoustab cella1 + 1 ?

you could use the (ancient ?) xl-4 macro-functions in 3 named-formulae as follows:

let's say you need to make a reference in [C14] to "some cell" (or range) in "previous sheet"

1) write in current sheeet [B14] the cell-reference (i.e. b2 or a3:a5 or whatever you need)
2) select [C14] (the next column where you wrote the cellreference) and ...
3) insert / name / define...

name formula
wbName =get.document(88)
wsList =substitute(get.workbook(1+0*now()),"["&wbName&"]","")
wsPrev =indirect("'"&index(wsList,get.document(87)-1+0*now())&"'!"&!b14)

while in [C14] (cell-reference in [B14]) you can use "the name" (wsPrev) as any indirect reference (i.e.)
[C14] =sum(wsPrev) <= will get the sum of the range-reference wrote in [B14] (ie. a3:a5)
[C14] =wsPrev+1 <= will add 1 to single-cell reference wrote in [B4]

hth,
hector.