Deleting non absolute rows of data...

Hi All,

My first post so hopefully I will get the information I require

I have been updating a report weekly for over 7 months, however one section of the report takes me just over an hour to complete, I will try my best to explain it below (with supporting image)

I grab a data dump which is approx 4000 rows long, however in order to prepare the data for the pivot table I need to delete 3 rows of data in between the multiple teams, (Total Sum, TM Name1, Title (highlighted in yellow)) so at present I am basically highlighting the 3 rows, right clicking and deleting the cells so they join up with no blank rows present.

I would be able to create a macro however that would only depend if the data dump lines up correctly from the previous extract, and WoW it doesn't as the teams are alligned by low to high %'s, so the cells will always change, hence the macro will be deleting the wrong data.

Does anyone know a way in which I can perform this task?

untitled.PNG

Thanks,

Hello and welcome to Ogrid.

In future threads, always post a sample workbook (fake data) to make it easier to provide an accurate solution.

Try adapting this and always test code on a back up copy of the workbook.
This code uses a helper column to facilitate autofilter by testing if values in column-A contain any of the three criteria you mentioned. If they do, then the formula returns TRUE and is the fitler criteria.

Note: this code *IS NOT* tested.

Please Login or Register  to view this content.