Good afternoon:
This formula works when an address is entered.  I need the option to enter
an address or a name and have it populate the same.
I sent an earlier posting, with an attachment,

I want to make it so that the word close is equal to 1:00 AM...  I can get 2
different cells to do that... but i need for example cell C3 to say close...
but the word close is equal to 1:00 AM so that my formula can still calculate
how many hours are workd

How can I have a plash screen when opening Excel?
I tried to do it the same way as in access but didn't work! It must be done
in a different way!!!
Any suggestions!

Does excel limit the amount of characters per cell that it will wrap?  I
have been editing a spreadsheet that my boss has been using for doing a
quarterly report.  She uses the cells for both spreadsheet and word
processing purposes because she has access to all sheets within the ...

I have a list which needs to  consilidated with another and then sorted
chronologically.  I  neede to lock or group together certain set of  rows  
please i am way past my deadline......thanks

Perhaps someone can help me..........
I have the following code written in VBA.
Private Sub SupervisorComboBox_Change()
Sheets("Sheet2").Range("C1") = SupervisorComboBox.Value

I've got a rather long mailing list in Excel and am not familiar with all the calculation features in Excel. Hoping someone can help me with this.
One column is zip codes (5-digit).  I would like to know how to make a list showing the number of entries in each zip code.   ...

New to Excel 2007.
I opened a book done with 2003 and has VBA code and macros...  I have the
following error message.
"Excel was able to open the file by repairing or removing the unreadable

Is there  a way to put in a tab within a cell?  I could manually
insert 5 spaces but it's cumbersome.  I know I could insert another
column but my columns are rather wide and the formatting is done with
left justification.  Thanks.

I have a table that has three columns - Name, X and Y. The Names are
is in ascending alphabetical order, X and Y are numeric columns.
I want to lookup a certain value of X and return the corresponding
Name, and repeat the same procedure with Y.

Good morning:
This is an example what I am trying to achieve
           Col-A                          Col-C
Row 1: Name                           Address

Good morning:
This is an example what I am trying to achieve
           Col-A                          Col-CO
Row 1: Name                           Address

I'm having a strange data sorting problem where my table won't sort a
column of values that are SUMs of other columns.
For example, the formula in Row 2 in the sorting column H is:
= SUM (A2, C2, F2, G2)

How do I copy all of a portion of an EXCEL Worksheet into a Woed Page,
including grid lines.  Then how do I set the cursor to type my message?
Please help.

Good evening:
Thanks in advance for your help
John
______________________________________________________