Macro to delete certain data
Hi
I have a report that comes with all kinds of surplus information that I am
trying to get rid of so I am left with the best bits. What I want to do is do
a macro to delete the words that are not needed, eg
- Evaluation Overview Report (this is the same throughout whole report)
- Generated: Mar 03 2005 16:15:12 <--- will change
- Quality: 64% <--- will change
etc etc
In the above the 1st will always be that but there are some that will be
different depending on when the report was run, the quality percentage and so
on
There are about 20 odd things that are duplicated possibly 300 times on each
page that I need to clear because what I will then do is delete all the blank
rows which will leave me with the data that I want. I can't take out the same
rows/columns at the start because they are not concurrent.
Any ideas on where to start on this? Any code snippets would be very welcome!
Cheers in advance
Linds
|