Hi Excel Forum!
First time poster, I was wondering if you guys would mind lending me your excel expertise for an issue I'm having making a finance tracker. I have sorted out most of what I need, except for a summary page I am working on. Each month is in a separate spreadsheet, and they are broken down into fortnightly lots.
What I need exactly, is a way to copy/paste a column of formulas that look like "=SUMIF('September 1'!B39:B138, "=Shopping",'September 1'!D39:D138"
into a new column, but with the "B39:B138" to "I39:I138" and a similar alteration for the "D39 etc" portion of the formula... At some point I will also need to know how to alter the formulate but only changing the "September" part to another month.
Would appreciate any idea in saving some time here! I have never really been taught how to Excel but it is providing invaluable for this task! I just need some help please!?