Can anyone help with a macro to sum up 15 cells in a column and place the total in the last row ?Template Strand SHIPMENTS .xlsm
Can anyone help with a macro to sum up 15 cells in a column and place the total in the last row ?Template Strand SHIPMENTS .xlsm
I looked at your file and I think your explanation above is a little lightweight for what you are actually trying to do. What you don't say above is that you already have a macro that creates several rows of summary data based on hundreds of lines of raw data above. You want to modify that existing macro to add the sum of each of the 14 category summary rows.
What I can't figure out is where you are creating the summary data in the range F517:R531, so I can't tell where in the code is the appropriate place to insert the sums. You have a lot of code to wade through and it would be very time-consuming for someone like me to analyze the whole thing.
Also, there are several opportunities for streamlining this code. For example, you have many lines to do this:
repeated 15 times, up to LR + 1. This could be done all at once like this:Please Login or Register to view this content.
The same applies to formatting for columns F, G, and H. You can replace hundreds of lines of code with this:Please Login or Register to view this content.
Please Login or Register to view this content.
I really appreciate your input on streamlining all of the coding and I will make the necessary changes. What I'm trying to achieve is adding a total by each Month. I'm currently using the below, but I'm having to to clear contents of one row after I have ran the macro.
Please Login or Register to view this content.
Can anyone help?
i SOLVED THIS WITH THE FOLLOWING CODEPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks