I'm trying to organize my companies stock a little bit mor
effectively.  Now I'm a rank amateur when it comes to excel.  
I'm trying to get a cell that when i type a number into it it'll add t
the pile.  Lets say I have 200 books.  I type 50 in this one cell an

I am looking for the command that will add together an amount from multiple
worksheets in a workbook from the same cell reference, for example, b4 from
sheet 1 and b4 from sheet 2 and b4 from sheet3. I am working on a large
worksheet and do not want to "tag" each one to build my ...

Using Excel 2002.  When I save the workbook (has many formulas and macros) I
get this message:
"Your formula contains an invlaid external reference to a worksheet.
Verify that the pathe, workbook and range name or cell reference

I know how to generate a random NUMBER.  I need to generate a random
PASSWORD.  ie: 8characters, numerals & alpha.  I'm guessing almost all of
you know how to do it.  I'd appreciate your help.
Thanks.

hi  
Experts
This is 2 part question
1>>>

Lotus had a data find function where you indicated criteria(Same heading as
the database - You could use more than one column) on another part of the
worksheet to search for. You selected / data, find and Lotus highlithed the
row that matches the criteria.

I am trying to enter "(c)" into a cell and everytime I do that, Excel
automatically converts it to the copyright symbol, which I don't want.
I've tried formatting the cell to text, general, etc. but that doesn't
work.

I've noticed that this group has some very helpful experts.  Here's one
for you.  I am trying to import a scanned document into excel using
scanning software called Paperport and a Brother MFC 3420-C.
I am getting nowhere.  Is OCR some extension of excel (2000) or am I in

GDay All,
Can anyone tell me why the folling function is not working correctly.
=LOOKUP(MIN(R10C4:R63C4),R10C4:R63C4,R10C3:R63C3)
The function works only if the lowest value falls within certain cells, but

We are using Office 2000 sp2.
On two machines, when we try to save a file it tells me that "The file
cannot be save and will be saved as ......"
The name of the file is Kevin-Brian.xls~RF1704920.TMP.

I've been asked to set up a spreadsheet where there are 3 columns for
possible "start" times, followed by one with a 2nd-stage time, which
then can calculate in the 5th column the difference between
whichever-start-time-applies (A, B or C) and the 2nd-stage time (D).

I have a simple doubt which I hope should be easy for you guys. I want
to make a cloumn in Excel with all entires having a check box for
yes/no. I find nothing in excel that will do this.
Alternatively, I can even do with restricitng the user to put just

Can any one help me, its simple if you know how. What is the formula to make
one cell absolute to another.

I need to convert or remove html tags in excel fields. I found a
suggestion here to copy the data into notepad and save as .html. This
works great however is not practical as I numerous files. Could this
possible done with VBA? Thanks for any help. I have been searching the

Can some one tell me if it is possible to automatically update the
(date) ranges in a graph?
Now I have to extend the ranges manually each time there is a new range
provided.