Excel 2000
Windows Server 2003
Someone wants to post an excel spreadsheet on the company's intranet, as a
.xls and not a .html.  However when two people view the spreadsheet

What is the formula that will add the content of a cell on one worksheet
(sheet 1) to the contents of  another worksheet (sheet 2)?
Thanks,
CJ

I need help with the following senario:
I have one row with names and the row below it contains numbers, I need to
be able to search the first row for the name each time it shows up then tally
the number that is below the name.  For example, Jane Smith is entered in 3

I have a spreadsheet that has only 85 rows and columns to AH. After
that the spreadsheet is gray. I checked, but there are no hidden rows
and the VBA code does not have anything apparent to hide or limit the
rows/columns. Could somebody explain how that is done?

If I have a value in one cell
can i use COUNTIF to add the sum in another range of cells?
i.e
value =2 in cell A1

This is probably a easy one, but need some help.  I need to import a
cvs file into a tab in my workbook call data without over righting any
of the other tabs from a command line.  Any help?

I have a simple question.
I have a column in a spreadsheet where some rows start with the letter
Q, and some do not.  I'd like to update the rows so that column is
prefixed with the letter Q on every row.

I am not an Excel expert by no means; however, I am building a template
for my quotations department to use. Is there a simple way to make the
cell that will contain the quote number automatically assign the next
sequential number? As an example, if a user used quote# 1000 on a

Some of the single column data that I copy from the Internet breaks into
separate rows when it is pasted into Excel. Is there a formula I can use to
bring it home to the correct row / text box? I paste an example, though there
may be 100 books in reality.  Each item should be on ...

I am exporting a Access report to Excel and the alignment and justify (some
are right and some are justified to the left) are not correct (need all to be
centered). How would I go about automating this when the export takes place?
Please help I am pretty new to Excel

I have this formula that caluclates
time"=IF(K27-E25+F25-L27<=0,0,K27-E25+F25-L27)".
in cell G25. It works fine if E25 is 11:00 PM and F25 is 11:30 PM. If I try
to calculate E25 is 11:55 PM and F25 is 12:05 AM it gives me 0:00. What is

I have inserted a page break into my worksheet but it does not respond.  The
taskbar says that it is there but it does not show up

I have a spreadsheet that when I filtered the data it use to provide the
number of records found (i.e. 11 of 41 records found) down in the lower left
hand corner of the window but it stopped doing this.  What happened and can I
get it to start providing this information again?

I can't get my grid lines to work on Excel. Any suggestions?

I have several named ranges in my spread sheet. Basically I want to vary the
name used in many formulas without having to manually modify those formulas.
For example:
There are many range names defined, say range_one, range_two, etc.