need help or advice on what to do

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using excel spreadsheet to manage the output of product for a window company. I would like to be able to assign jobs by area code in the worksheet. Is there a way to have select fields set to recognize area codes
 
Recognize? In what way? If you have a column that contains area codes, and
want to see only those records from a particular area code, try
Data-->Autofilter...
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
help said:
I am using excel spreadsheet to manage the output of product for a window
Click to expand...
company. I would like to be able to assign jobs by area code in the
worksheet. Is there a way to have select fields set to recognize area codes
 
I suppose a rephrasing of the question is in order. I am not even sure if excel can handle this but here is the question rephrased. I want an installer to do a certain area codes all the time. Is excel capabile of letting only (i.e. 562,626) certain area codes be allowed for an installer and deny any area code not specified.
 
Back
Top