Hello,
In the same workbook, is there a way to automatically copy from one sheet to
another sheet?
For example, multiple users will be putting various information, both

I am trying to set up a formula that will give me the remaining periods in a
lease. So if the end of the lease is Jan-2009, then i want to subtract the
current month from Jan-2009 to get a whole integer. ie. (17) months if Jan-09
is included.

I'm trying to add several fields together into a single cell to import into
another application where there will be line breaks
I have tried the following formula in several different ways.
=CONCATENATE(TEXT(I2, "mm/dd/yyyy"),CHAR(10),"MRN: ",A2,CHAR(10),"Dx: ",J2)

I need to find the value of x for the following equation.  The total of the
invoice is $1,000, but I need to find how much the original dollar amount was
without tax.  The tax is 5.5% and is included in the total of $1,000.  How
would a formula in excel be set up to be able to ...

What is wrong with this function?
=IF(Recap!A1=C112,1,0)
What I'm trying to do if I type in C112 into cell A1 then the selected cell
which is on another worksheet in the same book is equal to 1 then if not then

I have 2 worksheets, one with time used and the second with parts used.  They
are tied together with an ID number.  I want to create a link on the first
spreadsheet that returns all the values that match on the second
spreadsheets.  I would like the matching results displayed in ...

I am using the Vlookup formula to compare two files daily extractions.  The
#N/A value is retuned when there is correctly no match found.  I want to
create a formula in a seperate column, based on the results of the Vlookup,
that would return a text string based on those results. ...

I would like to have my conditional formatting applyed from one cell to all
the cells of my worksheet which are one the same line or to a range of
horizontal line, How can I do that?
Tks for your quick answer

I have a number of columns with a lot of rows:
A               U               V             W
Green         1              0              0
Yellow         1             0              0

I have multiple Excel spreadsheets containing data that is all upper case.  I
would like to modify the documents so that the only the first letter of each
word is upper case and the rest are lower.  There is a substantial amount of
data, so manually performing this process would ...

I need to make an average but some of the cells in range contain#div because
they are not completed with data in range in order to make my average
function work.
What i need i a formula which calculates the average of the cells with

How would I round up to the nearest 50 in an excell cell? MROUND won't work
as I always want to round up not down.
Also can I round up to non multples? I.e round up to to the nearest value
out of the following: 80, 100, 125, 160, 200, 250, 315

Hello, I am having an issue with the TREND function giving me a linear fit
when I need a polynomial fit.  It seems to happen in the following situation:
X       X^2        Y       Fit
-4       16        -20     =TREND(Ycolumn,BothXcolumns)

I have a spreadsheet with three basic columns,
Town       Category     Cost
Sheffield         A               £
Bath         B          £

Dear Expert,
I am creating a reporting format in excel.  I am finding it difficult to
make a drop down cells dependent on the other cell value.
e.g.  In one column i already defined a drop down list of some stages.  I