I have a list of values and subvalues on a worksheet called DataValues and am
trying to use the INDIRECT function for Data Validation as documented at
http://www.contextures.com/xlDataVal02.html.
I'm trying to create one column on an entry sheet that allows you to select

I have one worksheet. One sheet has data in the following fashion
03/01
OFFICER    - in    -  out    - MANUAL
Agent1      14       15       30

I was wondering if it is possible to have a drop down list put values into
different cells?
For example:  Down down box lists 10 different locations.  When a location
is selected I'd like to have several other fields in the same spreadsheet

I have information on employees in 2 spreadsheets.  Is there a way to link
all data for a certain SS#.  Basically I want all data to be side by side so
I can compare the data.  I'd like to have SS#, Data from SS1, Data from SS2
as my columns.  It's taking me forever to go through ...

Wondering how to use an If function.
I have information in A8 and D8 has a formula.
It does not matter if the information is in A8, B8, or C8 just as long as
the information is there and if so, then D8's formula will work, otherwise

I have 2 excel files linked.  I have a first & last name in the same cell in
one workbook and I want to link the cellin the second workbook,  but I only
want the last name in the result.  Any way I can do this.  I figured out how
to get the last name but not how to word it in the ...

I have a very long text in a cell. EX:
4919,"0.019999","7.2.84.192","10.160.18.52","RTP","PT=Unknown (99), SSRC=0x0,
Seq=343, Time=514216 "
I need to extract only the Seq=343 portion of it. The length of the text is

I am working on a sales spreadsheet and I need to take each month and find
the average increase or decrease in sales but using a %.
Example of spreadsheet:
January Sales

I am trying to count days in a period i.e. a month + having a start date
and an end date to calculate from.
I have too columns for log dates. These are:
StartDate        EndDate

Good morning.
In all my years, I’ve not come across this. Searched the Board; there’s a
post suggesting drop-down lists, but that would require too much ongoing
manual input (I think).

I have the a cell which contains various numbers (example 9123***********9)
I need to replace whatever the 2nd, 3rd, and 4th number is with a * leaving
everything else the same.  Can someone tell me how I can do this.

I downloaded a template and I can't change the theme.  Am I doing something
wrong?

I run a retail store and use excel to keep a list of all products sold by
having a source page where all the info is stored about all products and then
i have a page linked to the source page that when i enter the product number
the description and selling price of the product ...

In excell is it possible to change the colour of a number in a cell for
example if it goes negative?

I am trying to sort information in Excel 2003
I have a column of phone numbers - I am trying to sort them by U.S. area
code. The only sort function i see is alphabetical.
Is there a way i can do this?