I have created a worksheet for each individual person.  I am trying to create
a formula that will filter though the different worksheets  and sum the
people who have started on a specific date.  Can somebody please tell me how
to do this or if it can even be done.

I belief that there was a add-in that would show the names of tab in a
workbook.  You could click on the name and it would take you to that tab.

I am trying to count the number of enteries with the name information
although this is determined by a previous countif. Tha aim of this is to
allow the front page of a workbook be automatically updated.
Info: Example:

When one of the values in column 1 shows up
in cell "A1" I need the value across from it in column 2
to show up in cell "B1".
    (I'm using a drop down list to place the value in cell "A1")

I would like to know how to set up the first page in a workbook as an index
tab to the rest of the work book, so when you click on a cell it opens the
tab which is linked back to the index tab.

The SEARCH and FIND functions in Excel allow me to find text strings within a
single cell.  Is there a function that would allow me to search for a text
fragment in an array of cells?  The text fragment may be embedded in a longer
string (i.e., it would likely not be an exact ...

I have got a new keyboard (wireless) and using control plus left mouse click
will not allow me to select multiple boxes in Excel (or Photowise). The
"Plus" just jams and if I release the "Ctrl" button I have lost My first box.
(The same Problem happens when trying to open files I ...

I keep getting #N/A error every time I execute this formula. Here's the
situation:
My lookup range data resides in 'Data' sheet, and my formulas in 'Model'
sheet.

The help screen for “NPV(rate, value1, value2, … value29)” says the values
after rate are evenly spaced in time.  If the period is one year, then value1
occurs at the end of the 1st year, value2 at the end of the 2nd year.  In
example 2 on the help screen, this is true. Value1 = ...

Based on a response to my earlier post, I learned that Excel's autofilter
will only work up to 1000 unique different values max.
I visited MVP Debra D's page http://www.contextures.com/xlautofilter02.html 
as was suggested to me, and studied the options given.

I'm trying to create a workbook in which the column headings and row headings
appear on all worksheets...how do I do that?

I am trying to make an excel formula with one element repeating, and the
other filing down numerickly when I use the fill option
ex: a1*b1, a1*b2, a1*b3, but being able to do this in the fill option so I
don't have to right the formula aprox 5000 times

I am new in Excel, but I have some experience in general programming. I
have a problem with DDE dynamic formulas.
I have an application that maintains templates of Excel Formulas in SQL
Server. What I need is to load these formulas in Excel and evaluate

I'm doing a spread sheet with dollar values in excel worksheet. Each time the
dollar value ends in one or two zeros after the decimal the zeros drop out as
I move to the next cell. Why?

i want to write a macro
that would contain a do loop
and within that do loop i want to do sorting
can any one help i cant understand of how to select the cells that i