I have a document that I just need to extract specific information in and
build into a new document. Is there a way that I can extract than information
on a continous level. The info starts with the same first 3 letters but has
different endings? Any ideas??

I got a number of cell the first has the date the second has a number of
entry's in it, being completed, ss, inv, tl, and mgr, what I need is a way to
get the oldest date that do not have completed, so is there any way to get
the answer for this, it is to produce some thing like,

I would like to use functions to get values of columns that have numbers in
them after sorting them.  For example, after sorting, I would like to find
the average, standard deviation or mean for the numbers in the column.  
Please advise how to do this.

I need a formula the will update a cell at the start of the year to something
like 1/1/07 for 2007, 1/1/08 for 2008 and so on.
any ideas?

it´s possible, in excel 2003, using a function, counting the number of cells
in a colum that have text in black and text in red charaters.
ex: colum "payment"; (B5:B56); and counting employees in black text, and
employee in red text???

I want to generate a new form.
Sheet1:
Staff        Att'd. Date      Post       JOB
CHAN       01-04-07         PA         R8

I have a column of data with percentages of the total in the next column. I
now want to add a third column that shows the cumulative percentage of the
total. Something like:
    1    2       3

My friend tried to stump me, but he didn't say I couldn't use you guys to
find an answer...so here it is:
He has this summary data on one worksheet (but with MUCH more data
columns/rows):

Using Excel. I have created a graph using font size 14 for all words a numbers.
To find a number entered in the graph I click on Edit, then find. When I
type in the number I want to locate in the graph. The font in the find box is
like font size ( 8 ).

please help me
ActiveWorkbook.ActiveSheet.Range(Cells(4, 7), Cells((mData + 3),
7)).Formula = "=SUM()"
and

I would like to calculate the difference in two dates but in weeks. However
if the result is less than 1 week I would like the result rounded up to 1
week. Can anyone help I have had numerous attempts.

I have a list of data that I want to ensure is sorted when the user exits
from the worksheet.
Today I have a button with a macro attached to it (sort_data). But the user
will have to actually push the button. If he forgets there is a risk that

I have a sheet where I need to input either an AM or Pm  time in D2 and then
have it repopulate that time in B5 and add 1 hour showing AM or PM time.  
This can continue for up to 96 Hours.  For some reason I cannot add an hour
due to using the AM and PM in the hour.  Any help ...

I have a parts list that is VERY long and want to make it so that when people
go in and enter a part that they use, it will only print those rows that the
data was changed in, or are some how marked.
How can I make this happen?

Looking for Help..
I want to create 4 buttons with the forms toolbar.
but,
I want the first two to toggle (when one is clicked "ON" the other clicks