Hello everyone,
I've been struggling to figure this out for a while and I'm hoping someone out there knows the answer.
I have a workbook that I use to keep track of monthly bills. Each billing company has it's own sheet with relavant information including the bill total. Then I have one main sheet which lists just the totals of each month. I've created and attached a test sheet of what I'm trying to accomplish.
In this book I've created two sheets "Totals" and "Gas-Electric". In the "Totals" sheet I just want the totals from the "Gas-Electric" sheet. Typically in the "Totals" sheet Cell B3 the formula ='Gas-Electric'!E4 would be just fine but in the "Gas-Electric" sheet each month the total will be 3 rows lower. When you autofill it doesn't know to skip 3 cells. So Cell B4 in the "Totals" sheet should read ='Gas-Electric'!E7. B5 = E10, B6 = E13 and so on. I've color coated the cells I want equal to help out anyone trying to help. I'm looking for a way to create a formula that is able to autofill this in the Totals sheet.
I've tried the solution in this thread http://www.excelforum.com/excel-gene...ping-rows.html and haven't had any luck. I know it can be done with index and match but I'm looking for an easier way.
Thank you in advance for your help.
Bookmarks