I have 2 workbooks. One consist of a report cover page created with
textboxes, shading, etc. The second workbook has all of my data. I would
like to merge the two workbooks without losing any of my formatting.
I have a macro that creates the data portion of my report and just ...

Hello! I have several rows of data currently in which I would like to pull
data from. I could very easily use the LOOKUP function to do this. However,
both the lookup range and vector range are all numbers. I only want the
LOOKUP function to search for LOOKUP Values that are in a ...

Thanks to Biff for helping me get the first of my timesheet problems figured
out.  Now I am hoping to be able to take the amount of hours and multiply it
by a dollar amount to get a total.
So I want to take 25:30 (column a) and multiply that by $5 hour (column c)

I have numbers in columns A1:A100 and B1:B100.
I need the result for MAX(Ai / (Ai + Bi)).
Is there a way to write a worksheet formula and avoid populating an
intermediate column for Ai + Bi?

I have a worksheet with 35,000 row accros 10 colums with 1 column of phy-care
giver number (text but it think I can convert it to a number) and in a
separate table I have 3 columns of a list of 2,000 phy with the same
caregiver number. I would like to match to the lareger data ...

I run a dayhome and am trying to make my life easier on myself with my
attendance sheet but can't figure out why the formula wont work.  
I am trying to get the sum of hours and minutes each child is here during a
month so I can easily figure out what to charge the parents.

Why do I have to click the formula line every time to get the cell to update.
I put in the numbers and the cell with the formula does not update until I
click on the formula line. How do I fix this so it updates automatically?

I need code to give the following result: (I've tried and failed, tho I think
I'm close)
if A=0 then " "
else if B="Y" then (H8-(H8*O8))

How do I create a formula that will sum up a row based upon a particular date?

Somehow (in Excel) I inadvertantly turned off the left-right, up-down
directionals and started scrolling instead from column to column.  How do I
get back to the cells?

I am trying to create a spreadsheet where I can enter a date and have a date
27 days from that date pop into the cell next to it.  I need to do this for 7
months.  I don't even know if it's possible.  
For example, if I put the date 10/01/2008 into a cell, I want the

I need to average a set of figures in column A. my formulas not working - i
get the name error.
the figures are in A2 to A22.
Stupid question but how do I calculate the average for this figures in a

I need an if statement in cell a1 to change the text to red if cell f1 is
equal to zero. Can you help me?
Thanks,
Mike

I am trying to detect whether the value in cell M for each row has a
negative number.  If it does I need to change the text color for that
row to red.  
Any help, insights or links would be greatly appreciated.

Am using Excel 2003 - is it possible for it to automatically spell check as I
type.  I know I can check after everything is finished, but would like to see
errors as I work.  I am not talking about auto correct, which I understand,
but just general spell checking.