Macro to to enter value underneath last row in the last column

[kosherboy]

Hi.
Can anybody modify for me the code below so that the code will add the total sum of the last column underneath the last row? The code below works only for the last row in column "E", but I want the code to be flexible and detect the last column as well. Please note that my code also has an "auto fill down" which I would like to put in the last column as well.
Thanks in advance.

Please Login or Register  to view this content.

[kosherboy]

I tried working with the code to the best of my ability but the code doesn't work:-(

I pasted my entire code including scripts that I originally omitted.

I would really appreciate if anyone can shed some light on this issue.

Thank you.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe this can help?

Please Login or Register  to view this content.

[kosherboy]

Hi. Thanks for responding.
This code is not summing up the last row in the last column

[JOHN H. DAVIS]

It works for me. Can you attach a sample file with some data?

[kosherboy]

Here you go Row & Columns.xlsx. So basically what I would like is that the last 2 columns should be "filled down" with the formula in the last 2 columns in row "18", and then auto sum the last column in the last row. The reason for this is because there will be times where columns will be inserted however the last two column will always remain the same as far as formula wise.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[kosherboy]

Thank you again for your response. Your code is working but when I add additional columns the code is only working for columns D and E. See attachment Row & Columns.xlsm
It's possible I wasn't clear so I'm going to explain in detail what the code should do. Let's take into consideration that the amount of columns are unknown but the last 4 columns (the retail [which is needed for the formula], the quantity, the cost and the total cost will always be found in the last four columns. Working with these last four columns in order of retail, qty, cost and total cost I would like that the cost should = the retail * any given number (which I will would put in ,say, cell A1, so an example will be: the cell right under "retail" multiplied by the number in cell "A1").
Next, I would like to put the following formula in the cell right underneath "total cost" which will be the following: the cell underneath "qty" should be multiplied by the cell underneath "cost" (and that will = the "total cost". These four columns are not necessarily going to always be in the same columns but they will definitely always be found in the last four columns. Next I would like to have the last two columns "filled down" until the last row.
And the last thing I need is the total sum of the last column, so again the last column could be any column.....
Thank you for your time and patience and I hope to hear from you soon

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[kosherboy]

You are a genious!
To be honest I did not think this was possible! You have no idea what a breakthrough this is, Thanks and best of luck to you

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback and the rep!