I have a job list of all jobs we have in our shop, is has about 1500
customers on it with a company name, job description, date, P.O. # and Job #.
If I wanted to see all of company "A's" Jobs over the last year, how would I
do this? Thank you

Look in Help under the keyword FILTER
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tara" wrote in message
...
I have a job list of all jobs we have in our shop, is has about 1500
customers on it with a company name, job description, date, P.O. # and Job
#.
If I wanted to see all of company "A's" Jobs over the last year, how would
I
do this? Thank you

Tara wrote:
I have a job list of all jobs we have in our shop, is has about 1500
customers on it with a company name, job description, date, P.O. # and Job #.
If I wanted to see all of company "A's" Jobs over the last year, how would I
do this? Thank you

High light the entire sheet then go to Date Filter Auto filter
This will put a dropdown box at the top of every column. Go to
the Company field hit the drop down and select the Company you would like
to see.

gls858

Hi

assuming your column headings are in row 1 and your list of jobs start in
row 2 with no totally blank rows between each job, click in A2 choose data /
filter / autofilter ...
click on the little arrow that appears on the company name column and choose
the company you want
you can also filter on the date column - to get the info for a specific year
use the arrow and the word custom
in the first box choose
greater than or equal to and in the date box type the 1/1/05
choose
and
and then choose
less than or equal to and type 12/31/05

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tara" wrote in message
...
I have a job list of all jobs we have in our shop, is has about 1500
customers on it with a company name, job description, date, P.O. # and Job
#.
If I wanted to see all of company "A's" Jobs over the last year, how would
I
do this? Thank you