Need major help with calculating Sq. Footage from a range of cells

I have attached worksheet that I am in the process of creating for work. It is used for transferring materials. When you open the worksheet up I would like some help on programming some code that would allow me to take the Dimensions that a user enters in (Column G) and depending on the QTY (Column E) I could at the bottom of (Column G), lets say cell G29 could provide the square footage sum based upon what was entered by the user.

Any help would be greatly appreciated!!


Example.xlsm

Originally Posted by Mumps1

Try:

Please Login or Register  to view this content.

Mumps this is now calculating the sum, but if I go back and change my QTY after it finishes the calculation it won't update.

Originally Posted by Mumps1

Replace this line:

Please Login or Register  to view this content.

with this one:

Please Login or Register  to view this content.

Now it works Mumps!! Question, now when I change the QTY its not recalculating anything, its just adding to whatever the first calculation came out to be. Not sure what's going on.

I really appreciate you helping me fix this!

Originally Posted by Mumps1

I tried it on the file you posted and it worked properly. I had to unmerge the cells in row 29 first. The macro is designed to calculate all the dimensions from G2 to G28 taking into account the quantity in column E. Every time you change a cell in column E or a cell in column G, everything should be recalculated. Click this link to download your file: https://app.box.com/s/u3cniygca9r0jvhuvfkvu3ncan71tjj2

Your right it does work, thanks so much for helping me!

Let me ask you this, would there be a way to if I setup a table with a list of boats and in that table I had information about how much each specific boat can hold as far as tonnage and the total square footage it has available. Could excel based upon the Square footage number calculated / total weight of all items show in a drop down the boats it would fit?

CMRRedoExample.xlsm

I have attached my file Mumps, if you open it you will see an additional sheet. The one that says Sheet1 is where all of the data I believe you would need to understand what I would like to do. Once the user gets the total Sq. Footage from G29, I would like in K29 for a dropdown list to appear and based upon the number in G29, it would only show the boats that could possibly take the entire square footage amount. I'm thinking this would involve the VLOOKUP command but I’m not sure where I would begin.

Originally Posted by Mumps1

Try:

Please Login or Register  to view this content.

Worked perfect just like your other one!! Thanks so much for the help!