I have a routine/macro that populates cost of multiple items into column H of a worksheet (Sheet1). These costs are in groups. These groups can have 1 row, 101 rows or whatever, the numbers of rows change depending on how many items I need in each grouping. The number of groupings also change. After that macro runs, I need to sum the groupings. Right now, I have to pick each individual cell where I want the summed totals and then hit the AutoSum function. This can be very tedious, and I can miss some of the locations.
Does anyone know how to have a macro sum the cost of these groups in Col H after they are populated?
The range(s) of cells needing to be summed will already be formatted with a fill color of gray (See image below). The cell(s) that will have the summed total will already be formatted with the fill color orange (See image below). The hope is that a macro can find these formatted cells and create the range(s) needed and insert the sum function where needed.
I have scoured the internet and multiple forums to find a macro similar to my needs, as I know there are a lot of macros out there summing dynamic ranges, but I cannot find anything that resembles is what I need, and this is way over my knowledge of programing (which is very little).
Any help would be greatly appreciated.
Does anyone know how to have a macro sum the cost of these groups in Col H after they are populated?
The range(s) of cells needing to be summed will already be formatted with a fill color of gray (See image below). The cell(s) that will have the summed total will already be formatted with the fill color orange (See image below). The hope is that a macro can find these formatted cells and create the range(s) needed and insert the sum function where needed.
I have scoured the internet and multiple forums to find a macro similar to my needs, as I know there are a lot of macros out there summing dynamic ranges, but I cannot find anything that resembles is what I need, and this is way over my knowledge of programing (which is very little).
Any help would be greatly appreciated.