Formula Placement

Okay, this should be an easy one, but I'm not seeing it. I have a table of varying width. The last column of the table has the title of "Grand Total" in row 4, unknown column. I want to paste a formula in the cell one down and one right of "Grand Total" ("R1C1"), all the way to the bottom row of my table. The formula should pick up the value in the cell one to the left of and below "Grand Total" (R1C-1) through the end of the table and add that to the value in A5.

My code I usually use (below) won't work in this situation because I don't know what columns to use, and I don't know what formula to fill in.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Okay, I figured out part of the solution. In the code below the line beginning with "Lastrow" determines the last row of the table. The line beginning with "Range" pastes what I want in the cell to the right of and one below "Grand total".

Please Login or Register  to view this content.

Two things still to do:
1) I need to figure out how to combine the two lines so it pastes the formula all the way down to the bottom of my table.
2) I still need to figure out the formula to use

I'll keep plugging away, but I sure could use some help on this.

Could you attach a small workbook. May be just me but I find it hard to visualise things like this, I know others don't.

Sure. Workbook attached.

Still not quite I understand, and the guys above may have nailed it already, but here is my stab:

Please Login or Register  to view this content.

And Palmetto wins the prize! Great piece of work there. I had to make one small change, changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Look at my sample workbook and you'll see why.

Now, to complicate it even more, in the cells to the right of the cell we just populated I want to add the value from column A to the value we just plugged in, going out anywhere from 2 to 10 columns. Can we do that?

StephenR,

I tried your code, and it almost works. It posted the correct results, but in the last column with a heading, instead of the column following "Grand Total". See, "Grand Total" isn't the last title in row 4. I tried changing your 4 to a 5 and ran the macro, but there was no result. I changed it back to a 5, and it repeated the first behaviour.