Steve Belsch
01-02-2020, 01:10 PM
Hi VBA Experts,
I am looking for some ideas on how to accomplish the following.
I have attached two files for reference. One file has the before I run the VBA look and the second has the file post running the Macro.
If you look at the Post Running the macro file it will show you that I have added subtotals for each unique PO# and then I have added 5 blank rows. These blank rows are intentionally added for the Project Manager to populate with information and numbers if needed. But if you look past the last subtotal all the way to the first text where it says "CRO_1" I want to group those blank rows (not the 5 blank rows in each subtotal. And I would like to do this on each tab (for this example document I have reduced it to 3 tabs of data to reduce the size of the document. In the file I am working in it is over 250 tabs). And each tab will be different. It may be 50 blank rows or it may be 105 blank rows.
Any thoughts on how to accomplish this? Maybe a short DoWhile loop or something that just skips to the last "Subtotal" text and then finds all blank rows (based on column A) and groups them?
Thanks for any help and ideas.
Steve
I am looking for some ideas on how to accomplish the following.
I have attached two files for reference. One file has the before I run the VBA look and the second has the file post running the Macro.
If you look at the Post Running the macro file it will show you that I have added subtotals for each unique PO# and then I have added 5 blank rows. These blank rows are intentionally added for the Project Manager to populate with information and numbers if needed. But if you look past the last subtotal all the way to the first text where it says "CRO_1" I want to group those blank rows (not the 5 blank rows in each subtotal. And I would like to do this on each tab (for this example document I have reduced it to 3 tabs of data to reduce the size of the document. In the file I am working in it is over 250 tabs). And each tab will be different. It may be 50 blank rows or it may be 105 blank rows.
Any thoughts on how to accomplish this? Maybe a short DoWhile loop or something that just skips to the last "Subtotal" text and then finds all blank rows (based on column A) and groups them?
Thanks for any help and ideas.
Steve