Auto Fill Increment Formula

Hello Everyone!

I'm in need of some help and have extensively searched the past few hours for some help but to no avail.

What i'm trying to do is autofill this formula to worksheet Total Hours:

='GMS Hours!'L12+'Jeremy"s Hours!'L12


it needs to increment like so starting in cell H12 in sheet Total Hours:

='GMS Hours!'L12+'Jeremy"s Hours!'L12
='GMS Hours!'L20+'Jeremy"s Hours!'L20
='GMS Hours!'L28+'Jeremy"s Hours!'L28
='GMS Hours!'L36+'Jeremy"s Hours!'L36

On and on and on

I've tried selecting cells H12 to H15 and autofilling but that doesn't work correctly.

Please Help, I am about ready to tear my eyes out!

Thanks,

NF

Use a helper column to get your incremental values. In column I, (insert a blank column if needed and then hide, if desired) in cell I12 place a zero, in I13 enter 8. Highlight these two cells and copy down as far as you need. I14 will become 16, I15=24 and so on...

Now, in H12, copy and paste this formula:

=OFFSET(GMS Hours!$L$12,I12,)+OFFSET(Jeremy's Hours!$L$12,I12,)

Because I12 is zero, this will return the sums from L12 on both sheets

Now, copy this formula down as far as needed. H13 will now return the sum of L20 from both sheets, H14 will tally from L28 and so on......


Good Luck

Bruce

Bruce,

Great idea, but I'm still uncomfortable about the idea of insert/hiding a column. The reason is because I wont be using this to someone, but showing them how to do it. Is their another method to do this?

Sorry, I don't know of any "easy" way to do what you ask. You'll probably have to hand enter each reference. (copy a basic formula and edit the cell reference)

Bruce