Copying values between worksheets

  • Thread starter Thread starter ABriggs
  • Start date Start date
A

ABriggs

This seems a simple problem, but I can't find the answer: I am setting
up multiple worksheets (one per month); the closing balance on Jan
becomes the opening balance on Feb; if, for example, the opening
balance is in cell F38 and the closing one in F42, then in cell F38 in
Feb I enter =, then click on F42 in the Jan sheet. However copying
across to the other sheets results in all sheets referencing Jan!F42.


I understand why sheets can't be treated in a relative way, but is
there an easy way of copying this without resorting to VBA?

Cheers, ABriggs
 
Maybe you could put a date that the worksheet is using (say A1).

I put June 1, 2005 in A1 (a real date)
Then I could use a formula like:
=INDIRECT("'"&TEXT(DATE(YEAR(A1),MONTH(A1)-1,1),"mmm")&"'!a1")

To retrieve the value from the May worksheet (I brought back A1).

Then when you change the date, the formula reevaluates and gets the previous
month's worksheet's data.
 
Back
Top