Does anyone know how to have information from a cell located on sheet two
automatically update in a cell on sheet one?  I would like to create a face
sheet of shorts and enter my information on pages 2,3, etc, and then have
that information reflected on the face sheet.

I have an EXCEL 2003 worksheet containing addresses.  The street address
information is in two columns. For instance, for the address 123 Main Street,
the worksheet has one column containing "123" and another column containing
"Main St."

I know someone showed me this before, but I've forgotten.
If I wanted to do a count of the number of spaces within a single cell, how
could I do that?
For instance, if I wanted to look at a cell that contained 'A B C D', and

I am helping a friend with this and I believe he is using Excel 2000.
I  need to filter on multiple, non-concurrent columns.   When I select the
multiple columns I am told it has to be in a range.  Is there any way around
this?

I know if I want to do a formula for rounding to the nearest 100 of 40% of a
number it's =ROUND(a1*40%,-2).  This will automatically round to the nearest
100.  However, I am looking to round to the next highest 100 so if the value
is 2,101 it will round up to 2,200.  Any ideas?

I want to list our Departments birthdates.  By month, date and year would be
there but I don't want it sorted by year.

I have range A1:A5 i need to test for repeating cell contents
Array formula =countif($A$1:$A$5,A1:A5) works fine and for cell contents:
A,A,B,C,D returns: 2,2,1,1,1
Now I wish to test for repeating leftmost characters, ie for cell contents:

Hi! I have a long list with bank names and depost values. The list of banks
is sorted based on bank names. One bank can occur several times in the list
(but since it is sorted they come after each other). I want to have the sum
of deposit values for every bank. How can this be ...

I want to 'shadow rank' a number to determine how that number would rank IF
it were a part of the main group HOWEVER, I don't want to include it in the
main field, since it will increase 'n', lead to double counting and cause a
downstream domino impact if I were to include it.

Is there a site called :
bt.compudork.com ??

I am trying to demonstrate the usefulness of Excel by showing my kids how it
will calculate multiplication tables for them.  Using numbers 1 to 12 (for
example) across the x-axis and 1 to 12 across the y-axis would yield a
product.  Any assistance in using formulas?

After upgrading from Office 97 to Office 2003, the links in Excel workbooks
to other workbooks are not correct anymore.
Where there used to be a link to the workbook on a network drive (for
example H:\Excel\document.xls) the link now replaces H: with C:\Documents and

This is very irritating when entering formulas that reference pivotted data
in Excel. Can one turn this off?

I want to calculate the cost of phone calls where I have the duration in Hrs,
mins and secs and I also have the cost per minute. Do i need to convert to
minutes only first?

Based upon a date of birth input, can anyone advise how to populate three
cells with a person's age (cell 1 = years, cell 2 = months, cell 3 = days)
using Excel functions?