To all you excel gurus, thank you for taking the time to look at this call for help!
I've managed to hammer out every other problem I have had with this sheet, but I don't even know where to start with this particular issue (note, my experience with VBA has been minimal before now). What I'm looking to do is to take a group of data's subtotal description line (ie. "Group A Total", but not Group A's actual subtotal) and place it at the top of the grouping of data.
Because I'm sure that sounded confusing (it confused me when I first started doing these reports and they asked about it!), here's what I have
<tbody>
</tbody>
What I need is instead is something that looks like:
<tbody>
</tbody>
So, if this were to be at the top, A5 above C1.
The problem, of course, is that none of my categories are static (some are 12 items long, others are 2), and that sometimes there are 12 categories, and sometimes there are 20. Any help would be appreciated!
I've managed to hammer out every other problem I have had with this sheet, but I don't even know where to start with this particular issue (note, my experience with VBA has been minimal before now). What I'm looking to do is to take a group of data's subtotal description line (ie. "Group A Total", but not Group A's actual subtotal) and place it at the top of the grouping of data.
Because I'm sure that sounded confusing (it confused me when I first started doing these reports and they asked about it!), here's what I have
Group Name | Item No | Item Desc. | In Stock | Value |
Packaging | Wrap | Plastic Wrap | 45 | $39 |
Packaging | Box | Boxes | 52 | $10 |
Packaging Total | Total | $49 | ||
Group Name | Item No | Item Desc | In Stock | Value |
Elements | Zinc | Zi | 1 | $100 |
Elements | Oxygen | O | 25 | $150 |
Elements | Carbon | C | 5 | $50 |
Elements Total | Total | $300 | ||
<tbody>
</tbody>
What I need is instead is something that looks like:
Packaging Total | ||||
Group Name | Item No. | Item Desc | In Stock | Value |
Packaging | Wrap | Plastic Wrap | 45 | $39 |
Packaging | Box | Boxes | 32 | $10 |
Total | $49 |
<tbody>
</tbody>
So, if this were to be at the top, A5 above C1.
The problem, of course, is that none of my categories are static (some are 12 items long, others are 2), and that sometimes there are 12 categories, and sometimes there are 20. Any help would be appreciated!