Excel filtering program? - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 8 (permalink) Old 01-23-2007, 11:55 AM Thread Starter
Packin' up...
 
Skidmark's Avatar
 
Join Date: Jul 2003
Posts: 18,736
Excel filtering program?

Is there a way to make a program to filter in excel?

Like automatically filter column A to equal closed or equals resolved? Something to that extent.
Skidmark is offline  
Sponsored Links
Advertisement
 
post #2 of 8 (permalink) Old 01-23-2007, 12:24 PM
Timmay
 
Tiny Tim's Avatar
 
Join Date: Aug 2001
Posts: 4,898
Not sure what your asking but try data->filter->autofilter.
Tiny Tim is offline  
post #3 of 8 (permalink) Old 01-23-2007, 12:43 PM Thread Starter
Packin' up...
 
Skidmark's Avatar
 
Join Date: Jul 2003
Posts: 18,736
Quote:
Originally Posted by Tiny Tim
Not sure what your asking but try data->filter->autofilter.

I know that part of it. But i am tired of manually filtering things. The spreadsheets I work with have to be filtered multiple times to get the information needed out of them.

Like in one column I have to filter out certain things, in another column I need the blanks, in other column I need to non-blanks, etc.

I was curious if there was a program out there that would let you press a button and it does it for you!
Skidmark is offline  
 
post #4 of 8 (permalink) Old 01-23-2007, 01:07 PM
Timmay
 
Tiny Tim's Avatar
 
Join Date: Aug 2001
Posts: 4,898
Quote:
Originally Posted by skidmark
I know that part of it. But i am tired of manually filtering things. The spreadsheets I work with have to be filtered multiple times to get the information needed out of them.

Like in one column I have to filter out certain things, in another column I need the blanks, in other column I need to non-blanks, etc.

I was curious if there was a program out there that would let you press a button and it does it for you!
Ohhh. Record a Macro and you can add it as a button. Tools-Macro-Record New Macro. Just do your normal routine and record it so next time it can be automated.
Tiny Tim is offline  
post #5 of 8 (permalink) Old 01-23-2007, 01:23 PM Thread Starter
Packin' up...
 
Skidmark's Avatar
 
Join Date: Jul 2003
Posts: 18,736
Quote:
Originally Posted by Tiny Tim
Ohhh. Record a Macro and you can add it as a button. Tools-Macro-Record New Macro. Just do your normal routine and record it so next time it can be automated.
You just made my life so much easier.
Skidmark is offline  
post #6 of 8 (permalink) Old 01-23-2007, 01:38 PM Thread Starter
Packin' up...
 
Skidmark's Avatar
 
Join Date: Jul 2003
Posts: 18,736
Ah damnit, i'm having issues with it ; )

Are these macros accessible from one spreadsheet to another?
Skidmark is offline  
post #7 of 8 (permalink) Old 01-23-2007, 01:47 PM
Time Served
 
Join Date: Nov 2005
Location: Crowley
Posts: 268
You Can Link The Spreadsheets By Using Formulas, Do You Know How To Link Cells With Formulas In Excel?

97 GT ICEMAN C/A , ART CARR TRAN W/STALL , DEMON EC, 31 SPLINE REAR W/4:10'S , UNDERDRIVES & WHOLE LOT " HERE WE GO"

92 EAGLE TALON 2.0 AWD 5spd ,16G TURBO, 100 SHOT SPRAY.
STICKMAN is offline  
post #8 of 8 (permalink) Old 01-23-2007, 02:00 PM
Timmay
 
Tiny Tim's Avatar
 
Join Date: Aug 2001
Posts: 4,898
Quote:
Originally Posted by skidmark
Ah damnit, i'm having issues with it ; )

Are these macros accessible from one spreadsheet to another?
Store it in your personal macros. You'll see it as an option.
Tiny Tim is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

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

 
For the best viewing experience please update your browser to Google Chrome