In the attached Excel file in the tab titled "Current", I have some data that I rearranged in the tab titled "Desired".
Right now I am manually updating this based on the following criteria:
1. Insert two blank rows after any group of cells in column A that are merged.
2. Add a subtotal to the cells that are merged.
3. Insert one blank row after any cell in column A that is not merged.
Instead, it would be great if I could run a sub routine using VBA to accomplish this automatically. Keep in mind, my data table always starts in row 5, but the number of rows could vary depending on the amount of zones have in the table.
I appreciate any suggestions. This one goes way over my head. Thanks in advance!