you also culd use the indirect and address functions merged

eg. =indirecte(address(row number,col number, r1c1 ref, abs, worksheet name)

try to see the address function help, course all information could be in a
cell.

**************
hth
regards from Brazil
Marcelo
**************


"Sandy" escreveu:

Hi Marcelo
Thanks for the reply. Im not sure how this would help because I would still
have to reference the specific month. Im was hopiing something like
thissheet -1 to get to the previous month. Where thissheet would be the
sheetname or number.
Sandy

"Marcelo" wrote:

Hi Sandy,

did you think to named the cells? (insert | name | defined)

hth
regards from Brazil
Marcelo

"Sandy" escreveu:

Hello
I have a workbook with 12 monthly tabs(January-December (sheet 1- sheet12
respectively). Each sheet has begiinning and ending balances for different
accounts. Is there a way to generically reference the previous month/sheet
such as possibly using INDIRECT or Longre's sheetname() which I suppose is a
short cut to using
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

Example:
January!A1 Acct1 Beginning Balance
January!A2 Acct1 Ending Balance
February!A1 Acct1 Beginning Balance
February!A2 Acct1 Ending Balance

I would like to reference January Acct1 Ending Balance as February Acct1
Beginning Balance is a generic/indirect fashion.

I hope someone can make sense of this
Thanks!