Hi,  I'm a basic user of Excel and need to know whether or not I can use one
master spreadsheet to accumulate and total information from a number of other
spreadsheets and if so how?
Many thanks

Hello, all -- I got the below SQL to finally work and it will properly link
within Excel 2000.  I am having one problem and I hope someone can help me.
The below SQL SUM(PercentDown) column (which contains the percentage a
system was down) and divides by COUNT(PercentDown) to ...

Im trying to automate the process where when i enter someones date of birth,
i get the actual day that they were born.  The function weekday when used
only returns a value between 1 to 7.  How can i convert this Number value to
an actual day?

    I have a macro that does some copy and pastes from one sheet to another
in the same workbook. I want to then save the destination sheet with the
value of a cell as the file name. So the if the entry in X4 is 101 then
I want to save the file with the name 101.xls

I am tryng to set up a form for my trucking business and on MS Works I was
able to change the format from A, B,C,D,E, to names that were needed for my
form.  I can not seem to do that with Excel.  I am only computer smart as to
what I have taught myself so I don't know wether I ...

I would like to save the file on my HD and also to my Pocket PC folder for
synching. Do-able?

I have a spreadsheet where I need to continue to add new rows.  I want
to be able to copy a row with all the formulas intact, but none of the
values that may be in the row being copied. For example, if I have my
cursor on row 1, which may already contain values, I want to be able ...

Is there something similar to MsgBox that can be called via macro, only
instead of a message, I could put a couple of buttons inside of it giving
the user a choice of which sheet to jump to?

Thanks to a tip from Dave Peterson, he directed me to a site that has
example code which I've included.  There's also a link a the bottom of the
referenced page  to download a sample worksheet however it doens't appear to
be working. (hangs)

1. I have 2 columns : 1. start date 2. end date, how can I formulate in the
3rd column to show the difference in days?
2. I have dates in custom format i.e dd mmm yy but still on the formula bar
it shows as d/m/yyyy. When I type in the date 2/1/05 it shows as 01 Feb 05

Is there a way to tell the RIGHT function to extract all the characters in a
string preceding a second capital letter?
We have a data set that contains concatenated Firstnames and Lastnames.  For
example:

Can someone tell my how to eliminate the on - off pulsating which occurs
when my cursor is in either of  the Address Windows and the Subject Window
of a new message? I am not speaking about the Insertion Point, which should
be pulsating, but does not interfere with my typing.

How do I set up a search & replace to go through all of the worksheets in a
workbook when I click on 'replace all' not just the current worksheet?

On the Data->List menu in Excel you have a Create List option.
Where is an option to delete a list??? I can't find that option on the
Data->List menu. How do I delete a list in Excel?
Olav

How do I change my tab button to move right one cell at a time?