Would like to create code which will allow someone to type in a
specific number then would sort the spreedsheet to show just rows
that
have that specific number. I know you can do this with just using the
autofilter drop down, but I want to make it more user friendly buy
just having them type it in a cell then click a button.

Any help would be appreciated.
Tom

On Apr 1, 7:40 pm, Tom <to...@othy.com> wrote:
> Would like to create code which will allow someone to type in a
> specific number then would sort the spreedsheet to show just rows
> that
> have that specific number. I know you can do this with just using the
> autofilter drop down, but I want to make it more user friendly buy
> just having them type it in a cell then click a button.
>
> Any help would be appreciated.
> Tom

See if this is near what you want:
http://groups.google.com/group/micro...2907c960eb865f

HTH

Chris

Hi Tom

Take a look at the code in the FastFilter utility that I wrote, which is
available at
http://www.contextures.com/Fastfilter.zip
or
http://excelusergroup.org/files/fold...entry1194.aspx

Maybe that will help you.
--
Regards
Roger Govier

"Tom" <(E-Mail Removed)> wrote in message
news:988aab8c-68fe-4b2d-bd5d-(E-Mail Removed)...
> Would like to create code which will allow someone to type in a
> specific number then would sort the spreedsheet to show just rows
> that
> have that specific number. I know you can do this with just using the
> autofilter drop down, but I want to make it more user friendly buy
> just having them type it in a cell then click a button.
>
> Any help would be appreciated.
> Tom
>

On Apr 1, 8:00*pm, "Roger Govier" <roger@technology4unospamdotcodotuk>
wrote:
> Hi Tom
>
> Take a look at the code in the FastFilter utility that I wrote, which is
> available athttp://www.contextures.com/Fastfilter.zip
> orhttp://excelusergroup.org/files/folders/allversionwb/entry1194.aspx
>
> Maybe that will help you.
> --
> Regards
> Roger Govier
>
> "Tom" <to...@othy.com> wrote in message
>
> news:988aab8c-68fe-4b2d-bd5d-(E-Mail Removed)...
>
>
>
> > Would like to create code which will allow someone to type in a
> > specific number then would sort the spreedsheet to show just rows
> > that
> > have that specific number. I know you can do this with just using the
> > autofilter drop down, but I want to make it more user friendly buy
> > just having them type it in a cell then click a button.
>
> > Any help would be appreciated.
> > Tom- Hide quoted text -
>
> - Show quoted text -

That's a great utility! I now plan on using that same idea .. except
without the autofilter (I'd just hide rows) ... saweeet!

C

On Apr 1, 8:00*pm, "Roger Govier" <roger@technology4unospamdotcodotuk>
wrote:
> Hi Tom
>
> Take a look at the code in the FastFilter utility that I wrote, which is
> available athttp://www.contextures.com/Fastfilter.zip
> orhttp://excelusergroup.org/files/folders/allversionwb/entry1194.aspx
>
> Maybe that will help you.
> --
> Regards
> Roger Govier
>
> "Tom" <to...@othy.com> wrote in message
>
> news:988aab8c-68fe-4b2d-bd5d-(E-Mail Removed)...
>
>
>
> > Would like to create code which will allow someone to type in a
> > specific number then would sort the spreedsheet to show just rows
> > that
> > have that specific number. I know you can do this with just using the
> > autofilter drop down, but I want to make it more user friendly buy
> > just having them type it in a cell then click a button.
>
> > Any help would be appreciated.
> > Tom- Hide quoted text -
>
> - Show quoted text -

Roger,
This works great, just one minor issue. The wildcard feature will not
work on 95* numbers. I checked the format and is correct, can't figure
this one out.

Hi Tom

If the values are Text, then 95* will filter for 95, 950, 951, 9500 etc.
i.e. all text values beginning with 95

If the value is numeric, then you need to use >=95 ^ <=nnn
where nnn is the maximum number.

When dealing with numerical data, you cannot say the number begins with 95

--
Regards
Roger Govier

"Tom" <(E-Mail Removed)> wrote in message
news:29dad513-be74-4f1d-9653-(E-Mail Removed)...
> On Apr 1, 8:00 pm, "Roger Govier" <roger@technology4unospamdotcodotuk>
> wrote:
>> Hi Tom
>>
>> Take a look at the code in the FastFilter utility that I wrote, which is
>> available athttp://www.contextures.com/Fastfilter.zip
>> orhttp://excelusergroup.org/files/folders/allversionwb/entry1194.aspx
>>
>> Maybe that will help you.
>> --
>> Regards
>> Roger Govier
>>
>> "Tom" <to...@othy.com> wrote in message
>>
>> news:988aab8c-68fe-4b2d-bd5d-(E-Mail Removed)...
>>
>>
>>
>> > Would like to create code which will allow someone to type in a
>> > specific number then would sort the spreedsheet to show just rows
>> > that
>> > have that specific number. I know you can do this with just using the
>> > autofilter drop down, but I want to make it more user friendly buy
>> > just having them type it in a cell then click a button.
>>
>> > Any help would be appreciated.
>> > Tom- Hide quoted text -
>>
>> - Show quoted text -
>
> Roger,
> This works great, just one minor issue. The wildcard feature will not
> work on 95* numbers. I checked the format and is correct, can't figure
> this one out.

Hi

I don't understand why you would not wish to use the power of Autofilter,
which is so fast (and easy).
If you don't want the Autofilter dropdowns to show, you could just hide
them.

dim colnum as Integer, c as range
Column = 10 ' change to suit

For Each c In Range(Cells(testrow, 1), Cells(testrow1, colnum))
c.AutoFilter Field:=c.Column, _
Visibledropdown:=False

Next

--
Regards
Roger Govier

"cht13er" <(E-Mail Removed)> wrote in message
news:5309a94b-c74d-47b8-8c2c-(E-Mail Removed)...
> On Apr 1, 8:00 pm, "Roger Govier" <roger@technology4unospamdotcodotuk>
> wrote:
>> Hi Tom
>>
>> Take a look at the code in the FastFilter utility that I wrote, which is
>> available athttp://www.contextures.com/Fastfilter.zip
>> orhttp://excelusergroup.org/files/folders/allversionwb/entry1194.aspx
>>
>> Maybe that will help you.
>> --
>> Regards
>> Roger Govier
>>
>> "Tom" <to...@othy.com> wrote in message
>>
>> news:988aab8c-68fe-4b2d-bd5d-(E-Mail Removed)...
>>
>>
>>
>> > Would like to create code which will allow someone to type in a
>> > specific number then would sort the spreedsheet to show just rows
>> > that
>> > have that specific number. I know you can do this with just using the
>> > autofilter drop down, but I want to make it more user friendly buy
>> > just having them type it in a cell then click a button.
>>
>> > Any help would be appreciated.
>> > Tom- Hide quoted text -
>>
>> - Show quoted text -
>
> That's a great utility! I now plan on using that same idea .. except
> without the autofilter (I'd just hide rows) ... saweeet!
>
> C

On Apr 4, 7:16 pm, "Roger Govier" <roger@technology4unospamdotcodotuk>
wrote:
> Hi
>
> I don't understand why you would not wish to use the power of Autofilter,
> which is so fast (and easy).
> If you don't want the Autofilter dropdowns to show, you could just hide
> them.
>
> dim colnum as Integer, c as range
> Column = 10 ' change to suit
>
> For Each c In Range(Cells(testrow, 1), Cells(testrow1, colnum))
> c.AutoFilter Field:=c.Column, _
> Visibledropdown:=False
>
> Next
>
> --
> Regards
> Roger Govier
>
> "cht13er" <cht1...@gmail.com> wrote in message
>
> news:5309a94b-c74d-47b8-8c2c-(E-Mail Removed)...
>
> > On Apr 1, 8:00 pm, "Roger Govier" <roger@technology4unospamdotcodotuk>
> > wrote:
> >> Hi Tom
>
> >> Take a look at the code in the FastFilter utility that I wrote, which is
> >> available athttp://www.contextures.com/Fastfilter.zip
> >> orhttp://excelusergroup.org/files/folders/allversionwb/entry1194.aspx
>
> >> Maybe that will help you.
> >> --
> >> Regards
> >> Roger Govier
>
> >> "Tom" <to...@othy.com> wrote in message
>
> >>news:988aab8c-68fe-4b2d-bd5d-(E-Mail Removed)...
>
> >> > Would like to create code which will allow someone to type in a
> >> > specific number then would sort the spreedsheet to show just rows
> >> > that
> >> > have that specific number. I know you can do this with just using the
> >> > autofilter drop down, but I want to make it more user friendly buy
> >> > just having them type it in a cell then click a button.
>
> >> > Any help would be appreciated.
> >> > Tom- Hide quoted text -
>
> >> - Show quoted text -
>
> > That's a great utility! I now plan on using that same idea .. except
> > without the autofilter (I'd just hide rows) ... saweeet!
>
> > C

That's a good point, Roger - I didn't think of that I'll take a
look at what that looks like, now
Chris