I have a
expenses sheet, and other sheets named
Feb, etc. These sheets are identical except for their numerical values.
expenses sheet I want to have columns, each of them applying to a separate month, and I want these columns’ cells to reference information inside the relevant month’s sheet.
For example, for January, I will have cells of the form
=SUM('Jan'!$D2:$Z2). I of course have many such cells (each referring to a different row in
Jan). How can I generalize this so that I’ll have this behavior for the other months? That is, so that the relevant cells will be of the forms
Or, to summarize the question: How can I copy multiple cells that reference another sheets so that only the sheet to which they are referenced is changed?