Is it possible to have one spreadsheet (A) linked to another spreadsheet (B)
so that any changes made to (A) are automatically recorded in (B)?

I'm trying to compare two cells to create two different outcomes. The
formula I'm using is as follows;
=IF((AND(H15="Capitol",I15="both")),F15/2,),IF((AND(H15="Capitol",I15="MPL41")),F15,)
Cell H15 does equal Capitol, Cell I15 does equal both, Cell F15 does

have check number such as 00356. When entered in a cell and pressing enter,
it shows 356.
How can we keep it shown as 00356? and what cell format is necessary if any?

still trying to find a way to use 2 criteria within 2 ranges to add 1 range
of data;
range1    range2    criteria1    criteria2    data
=sumif(range1,criteria1,data)+sumif(range2,criteria2,data) will give twice

hi, i have 2 worksheets.. using a vlookup to return data from
worksheet A to worksheet B.
Worksheet A has some formulas in the cells, and when I do a vlookup to
worksheet B it only returns the values, not formulas... is there a way

Hi
I need to do a basic if function. in cell A1 it may say "14" so in cell A2 I
want to display another number ie "1", If A1 has changed to "18" I want A2 to
display "2", If A1 changes again I need to display "3" etc.  I need five

I have a sheet that has numeric data and also alpha numeric data on it
I am using a lookup table to sort out the naming of the numeric's
e.g
12.12.12   Bill

I’m trying to fix a messy imported data set.  The CLEAN formula removes
unprintable characters, but also removes separation between multiple words.  
Is there a way to replace unprintable characters with spaces or delimiters
such as commas?  Thanks.

I have a pivot and I need it to count the number of unique values.  Is this
possible in a pivot?

I'd like to have unique headers for parts of a worksheet when I print
the data.  Is it possible to create sections within a worksheet?
Otherwise, if I have each set of unique data in separate tabs, eahc
tab having it's unique header text, is there a way to create a pdf

How to select different cells with only keyboard movements in Excel?
Trish

I would like to create a macro (or vba function) that subtotals by user
then by type.  I have two fields that I would like to total, amount and
reimbursement amount.
I would like the macro to sort and subtotal on type and then provide a grand

When starting up and shutting down Excel 2007 I get the error message,
"Compile error in hidden module:  DistMon.  It seems to work ok in spite of
this.
Any ideas on how to fix this?

my question is about the Application.OnTime Method.
Usually I use it after having these two variables defined:
Public RunWhen As Double
Public Const cRunIntervalSeconds = X

I print out a register, 1 for each day of the month is there anyway of
incrementing the date for each one, so i don't have to change the date each
time i print it out.