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

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.)

Tom wrote:

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

--

Dave Peterson

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

"Dave Peterson" wrote in message
...
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.)

Tom wrote:

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

--

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.)

Tom wrote:

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

"Dave Peterson" wrote in message
...
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.)

Tom wrote:

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

--

Dave Peterson

--

Dave Peterson

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

"Dave Peterson" wrote in message
...
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.)

Tom wrote:

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

"Dave Peterson" wrote in message
...
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.)

Tom wrote:

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

--

Dave Peterson

--

Dave Peterson

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" wrote in message
...
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

"Dave Peterson" wrote in message
...
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.)

Tom wrote:

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

--

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.

Tom wrote:

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

"Dave Peterson" wrote in message
...
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.)

Tom wrote:

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

"Dave Peterson" wrote in message
...
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.)

Tom wrote:

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

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson