Excel 2003 Wizards?

[MJP08]

Hi, is there a way to set up an Excel spreadsheet so it will automatically
delete certain rows or columns?

For example, I have a report I cut and paste into Excel from a website and
it shows multiple lines of "Call Summary" followed by a ton of data. These
lines are duplicates and I want to be able to have them disapear without me
clicking on each row and deleting it. Is that possible?

 

[Gord Dibben]

Show us a small sample of the data and explain which rows/columns to be
deleted from that sample.

But yes........Excel can be programmed to do that.

Or maybe just adding a filter to filter out what you don't want?

Do you want to keep just one of each of the duplicates?

That can be done through Advanced Filter for Unique records only.

Hard to say.


Gord Dibben MS Excel MVP

 

[MJP08]

Oh geez, the report is going to be huge, but here's the top few lines. I
don't see a way to attach the actual spreadsheet into this post so I'm sorry
if it comes across as total junk. I want it to be able to get rid of rows
1-4, 9-11 and all of the ones that says Call Type Summary.

Printable Version

Call Type Daily Report
From: 7/23/2008 00:00:00 To: 7/23/2008 23:59:00
Enterprise Name SL Aband SL Aband SL Aband Aban
Within ASA Tasks Completed Tasks
Ignored Positive Negative Service
Level Offered Assigned Answered Answer Total Handled Aban Return Default Network Flow Calls Other % Queued % Aban Avg Aban Short
Date From Queue Wait Time Treatment Routed Out Error Delay
Time Calls
Run by: TELECOM Report name: WA MS Daily Reports 2
Run Date: 7/24/08 12:38:22 PM PDT Template name: caltyp22
Copyright 1999-2005 Cisco Systems, Inc
CT_WA_Eligibility (5177)
7/23/2008 92.54% 92.66% 91.14% 6 0:00:09 395 58 386 1:01:38 395 386 6 0 0 0 0 0 3 13.99% 1.52% 0:02:04 0
Call Type
Summary 92.54% 92.66% 91.14% 6 0:00:09 395 58 386 1:01:38 395 386 6 0 0 0 0 0 3 13.99% 1.52% 0:02:04 0
CT_WA_Member_BasicHealth_EN (5048)
7/23/2008 91.96% 91.96% 91.96% 0 0:00:10 199 36 199 0:33:30 199 199 0 0 0 0 0 0 0 18.09% 0.00% 0:00:00 0
Call Type
Summary 91.96% 91.96% 91.96% 0 0:00:10 199 36 199 0:33:30 199 199 0 0 0 0 0 0 0 18.09% 0.00% 0:00:00 0

 

[Gord Dibben]

Too much line wrapping to be able to made sense out of this.

I don't know what rows 1-4, 9-11 are and Call Type Summary is on two rows.

A small sample would be half dozen columns and say a dozen rows.

What column would we be searching on to find Call Type Summary?

Would you want rows 1-4 and 9-11 deleted every time you cut and paste?

Try this on a copy of the worksheet.

Sub DeleteRows()
With ActiveSheet
Rows("1:4").EntireRow.Delete
Rows("9:11").EntireRow.Delete
FindString = "Call Type Summary"
Set b = Range("A:A").Find(what:=FindString, lookat:=xlWhole)
While Not (b Is Nothing)
b.EntireRow.Delete
Set b = Range("A:A").Find(what:=FindString, lookat:=xlWhole)
Wend
End With
End Sub

Ammendments are possible.


Gord