Ok, here's the quandry that I'm in...  I have a given set of numbers,
and a known total.  I want excel to figure out for me which of those
numbers sum to my total.   For example:
Code:

I want to put conditional formatting into a cell where I want excel to change
the color of the date in the cell if it date is anywhere between today's date
and 2 months prior to today's date.
So if today's date is August 12th and the date in the cell is anywhere

I need formula in column M to count number of blank cells in column L since
the last entry
Sheet looks like this:
L2   1       M2

I have a spreadsheet that performs vlookups from several other sheets.  From
time to time new sheets are added and I would like to be able to change one
cell and have all the vlookups change to that sheet.
For example,

Is there an add-in or a way of allowing Auto Filter to look beyond
1,124 rows?
Thanks for your help
Tom Snyder

I'm looking for a way to refer the Indirect(Address(... functions to yield a
result from a cell in a different page of my spreadsheet.  Any help?

       A                 B              C
1     DATE        RECOVERY     MTD
2  1/1/2005        95.36%      95.36%
3  1/2/2005        95.17%      95.26%

I have forgotten how to reflect data that is present in one worksheet
cell into a specific cell of a second worksheet.  IOW, repeat cell
contents in a second worksheet.
I remember that I must first point to the specific cell that is to be

I am using a macro to split a large workbook into multiple worksheets.  The
macro automatically names the worksheets based on the specified column.  
However, if the field length is too long it actually has to be manually
renamed.  Do you know if there is a way to extend the ...

This function does not recognize a cell referrence (or a number directly
input) for the second input, number of periods.  Instead it returns #N/A.  

I have a column of 10 numbers.  The last row of the column is a control
value.  I would like to know the easiest way to see if any of the previous 9
numbers in a column divided by the control number is .6 or less.  I tried OR
function and it works, but I will be dealing with ...

I am trying to have a single point on a worksheet that has 3 cells (name(A1)
then street address(A2) and city, state, zip(A3).  I have a place in the
worksheet that has the names listed in column (R) Street Addresses in column
(S) and City, State, Zip in column(T).  I want when I ...

I noticed that many time the drag/double click option to increase the value
in the adjacent cell by value step = 1 (or 10, etc), doesn’t work (I don't
know why).  In that case, I have to do it from the ‘Edit/Fill/Series.’  How
could I activate/deactivate the automatic function.

I have a worksheet that subtotals the Amount (Column C) after each Dept ID
(Column F) changes.  Is there a way I can get each subtotal cell, which is in
column C, to BOLD?  Thank you.

i want to maintain one main worksheet with ALL the info and separate it into
multiple worksheets.  when i make changes the the multiple worksheets (within
the same spreadsheet) i want the same changes on the main worksheet.... is
this even possible.