I have 3 columns in sheet2 designed as follow:
A         B         C
1          John    6
2          John    7

I have a spreadsheet that I would like to total at the bottom. But I don't
want to have to keep inserting rows when it fills up. Is there a way to have
the total at the very bottom of the spreadsheet, but still have it print out
on a report with all the data?

I need a formula to substract numbers in non contigous cells THAT ARE
IN ONE COLUMN and have the result in other cell, for example:
.......................A...................B
R1..................................BLANKCELL

I have two worksheets that have the same info on one as the other such as
names. To cut my work load in half I would like to know how to insert the
name in one form and it automactly insert the name in the other worksheet.
How do I do this?

I copied a formular down 10 cells for future input. The cells are all
showing 0.00, until I enter a value on the other side where the calculation
will originate from. Can I hide those zeros and still have my formular
intact.

I am writing a VB script for excel, after I paste my data into the document
from a different file,
I have a formula that tells me how many rows are used, and that value is
stored in a cell,

I use Excel to create quotes and than manually have to transfer the
information into the form I use that I created in Word can this be automated
easily?
Marc

I inherit an excel spreadsheet which contains the course schedule for a
college.  It contains fields like course number, subject, section number,
days, times, room, instructor and credits.  There is a unique number
assigned to each course offered.  However, it sometimes happens that ...

I know how to set up newsgroup into my Outlook Express but it seems that I
can't find the correct server name to this newsgroup. Can someone tell me?
Thanks
kendee@hotmail.com

I want to show a list of descriptions in a combo box on a form.
When the user makes a selection I want to put an associated data value into
a cell...
My descriptions are in.. A1 thru A5

I need help totalling entries of names any lable in a column. For example,
when I enter a name, I will like the Total column to show 1, when I enter
another, it should show 2, etc. Can anyone help.
Thanks in advance.

How do I get a title to be printed on the top of the worksheet?
For instance, Attendance, January - March, 2005

Good Morning All,
Using Excel XP.
I have a workbook with 100 worksheets.  On all of the sheets I have certain
cells that are protected.  Is there any way that I can protect the sheets

I am current trying to determine how Excel calculates PercentRank.  
The project I am working on requires the use of this function - and we
cannot use COM automation to call Excel.
The only documentation I could find was the following:

Maybe I just haven't played with SUMPRODUCT enough yet to figure this
out.  Take a look at the sample below.
http://www.batattak-records.com/Book1.xls
Beginning in A1 I have the list of Supervisor names.  In cells B1:B5 I