LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Lindsey M
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting excess data in a macro ChuckW Excel Discussion (Misc queries) 3 February 24th 05 06:48 PM
Extract specific data into its own workbook via macro? Adrian B Excel Discussion (Misc queries) 2 February 24th 05 06:09 AM
Macro does not run when data refreshed Larry Lehman Excel Discussion (Misc queries) 0 January 16th 05 07:31 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Daily Macro to Download Data, Order and paste in order Iarla Excel Worksheet Functions 1 November 17th 04 01:59 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"