filter errors depending on number of incidents

T

Tom

Hello,

I have a sheet that looks like this

BugID #occurances
Bug#12123 4
Bug#11128 2
Bug#18145 3
Bug#15123 4

How can I create a second sheet that would have only those
BugIDs & Occurances that have occured more than two times.

Please help!
Tom
 
D

Dave Peterson

Select your range (columns A:B)
data|filter|Autofilter
use the dropdown arrow in the occurances column
and choose Custom
greater than 2

select the visible cells and copy to a new sheet.

(If you use the filter, maybe you don't even have to do the copy|paste.)
 
T

Tom

ohh i'm sorry i wasnt clear

this second sheet will be with my boss.

What I'm trying to do is update my sheet
and hoping that the boss's sheet picks
bugs ids that have been reported three
times or more. Also i'll keep adding new
bug ids to this sheet and those too should
show up on my boss's sheet if reported
more than twice.

sorry for the confusion :)

thanks
~t
 
D

Dave Peterson

I'd do the data entry in one spot, then create the boss's report each time I
needed it.

(Or just give the boss my sheet with the filter applied. I've found that if I
create that report for my boss, then the next thing that happens is that he
updates stuff. But I don't know what or where. By having the data in one
single spot, it makes life much easier.)
 
T

Tom

wish that could work for me :(
is there any fuction(s) that would
allow me to do this ?
 
J

Jim May

Pursue Dave's suggestion, using Data-Auto-Filter.
After Filtering run (Macro) tester:

Sub tester()
ActiveSheet.Copy
End Sub

This will create a new workbook (default name Book1.xls); Do a File Save-As
and forward to "your-boss".

HTH



Tom said:
ohh i'm sorry i wasnt clear

this second sheet will be with my boss.

What I'm trying to do is update my sheet
and hoping that the boss's sheet picks
bugs ids that have been reported three
times or more. Also i'll keep adding new
bug ids to this sheet and those too should
show up on my boss's sheet if reported
more than twice.

sorry for the confusion :)

thanks
~t
Click to expand...
 
D

Dave Peterson

I think it the easiest solution would be to apply the filter and copy those
visible cells to a new sheet.

If you really want a macro solution, record one when you do it manually (one
time). If you have trouble, post back with your questions.
wish that could work for me :(
is there any fuction(s) that would
allow me to do this ?
Click to expand...
 
Top