I'm trying to create a macro that will automate a report. Issue is, the source data brings through data we don't need, and the report itself does lots of calculations based on the table as a whole. There's hundreds of calculations being done based on the table so adding in an inclusion parameter to each formula in the report is going to take a prohibitive amount of time.
This is easily worked around when updating the report manually, by using the filter, filtering data out, and deleting the relevant data. I'm trying to automate the file however, so we can just click a button and refresh it without having to spend 20-30 minutes doing so.
What I therefore want to do, but have failed to work out so far, is have VBA delete every row where a column contains a certain string.
This is as part of a larger macro, which updates data, corrects a dates column using Text to Columns, deletes a section of data, calculates the formulas in the KPI's sheet, and then saves it as this weeks date.
I can automate all of the other steps ok as I've already created several macros to update other reports, but this has stumped me! My Google-Fu has failed me too.