I have six workbooks; 5 work fine however the sixth will not display wrapped
text in cells on the main worksheet. The text does wrap, but the row height
isn't automatically adjusted to display it all.
There are merged cells in the worksheet, but not in the area with the

I have a spreadsheet named "UFMS" containing budget information.  Dates are
in column A, currency in column H.  The  sum of the money is in cell H13
(SUM(H4:H12)).  When I insert the next record, the sum will be in H14,
(SUM(H4:H13).  So the sum will move down the sheet.

In an expression, how do I refer to the last cell in a specified column that
is not blank?
Thanks in advance.
H

I have several spreadsheets that contain customer information, ie. name
address, etc.  These spreadsheets have been sent to us by the manufacturer we
represent.  One group of spreadsheets has a space before the text in every
cell, while the majority of the spreadsheets do not.  ...

I am searcing for an answer to Excel 2003 and Excell 2007 not working
properly when I apply the Autofit Row Height option.
I have read most, if not all, of the responses on this and other sites and
they all want to point to there being merged cells involved.  

I have a file like this
Name     Address     City                     State      ZIP
Zimmer  221 W 10    ATLANTA, GA                   11111
So the CITY field contains both the City and a comma, state

I have a form for other users to enter information.  I think I need a text
box that will expand and wrap based on the amount of info entered by the user.
Can the group give me some advise on the best way to set this up, or offer
another suggestion?

How can I creat following formula in cell A1 ?
 If B1 is <0 then in A1 A
 If B1 is >0 then in A1  B
 If B1 is =0 then in A1  C

I have two columns of data. One column has the gender and the column
alongside has the age of these people. The columns are mixed with males and
female. How do I determine the average age of just the men and just the women?
example:

Can someone tell me how to get a splash screen to come up only after a
certain date??  I know how to put the code in a userform, but have no idea to
only have it pop-up after an expiration date.  I have a form that expires
each quarter and I want the user to see a pop-up window ...

I have this formula:
=IF(COUNTIF('Employee Attendance'!3:3,">="&DATE(2008,4,1)) -
COUNTIF('Employee Attendance'!3:3,">="&DATE(2008,5,1))>0,"No","Yes")
I would like it to keep the cells blank and only complete the calculation

I have a sumif formula counting a rolling 6 month period that is summing
total points only accumulated in that 6 months.  I'd like to add conditional
formatting that will only change the color if that particular instance of
earning points is being counted in the sumif formula.  I ...

I have a spreadsheet that we are tracking billing statements for Medical
Records, and I am struggling to get my formula to work the way I want it to.  
We send a past due notice at 30, 60 and 90 days if no payment has been
received.  

I work with large databases in xl where the dates are formatted as a day
(e.g. 3/21/08) and I want to reformat the date so that the format is a
general format  for month (e.g. "3" or march).  I know how to reformat (using
custom format 'm').  Issue is that xl still treats it like ...

I have a userform which has a number of textboxes. They are titled "Start
Date" and "Expiry Date".
How do I get the expiry date to change colour when 30 days before expiry
date the font changes to orange and when past the expiry date it changes to