Remove total lines from monthly report

[PraveshG81]

Hello,

I receive a report from a teammate that breaks down each line of business (LOB), the specific activity for that LOB, the revenue made Month to Date and the revenue made Year to Date. This is done for 7 of our line of businesses.

I use this report to do some pivot tables and other analysis but before i can do that i insert a new worksheet in the workbook copy the data over and reformat the report by removing the row that has the title for the LOB, the row that tells me the moth to date total the row that tells me the year to date total and and empty rows in between. Anyway this takes way to long and to much work, is there a way to write a macro or a formula to do this all automatically? Please see attached example