I have made some references to other cells in other worksheets in my
workbook through VBA: worksheet.cells.formula = "= 'otherworksheet'!C2"
But when I update the source cell, the target cell doesn't automatically
refresh.

I am trying to link a cell ( an item price) in 1 worksheet to another
worksheet and have the correct price displayed regardless of any sorting of
data that I do.  When I set up a link it works well except when I sort the
data in the worksheet 1 or 2

I have a simple table with the years heading the columns and a grades heading
the rows:
    2000    2001    2002    2003    2004    2005
1    2.1    2.3    2.5    2.6    2.7    2.9

I have a ss that in certain cells I am doing a couple of calculations. These
answers do not need to be seen in these cells. To make the spreedsheet look
better I have shaded these cells containing these formulas and I have also
colored the font the same color. When I print off ...

I want to copy the subtotaled data to another part of the worksheet or a new
worksheet without the underlying details. If I click and drag the area I want
to copy it picks up all the hidden rows. I don't want them.

I'm trying to change the cell height and wideth on different pages within the
same worksheet. I have over 40 pages on the same worksheet and some need to
have different cell sizes.

I have a cell that contains one long sumproduct formula. It is basically
combining 3 results into 1 cell with a "/" separating them. This formula is
repeated 448 times For the past week the formulas have worked great, but
today they only return "#N/A". My process for updating the ...

I have a table as below
if the refdensity is less than 31 then i want to count the coresponding
conversion (0 to 5)
if the refdensity is between 31 and 65 i want to count the coresponding

In cells C2:C4 I have three start dates
In cells D2:D4 I have three end dates
In cells Q20:Q50 I have dates in random order
In cells R20:W50 I have numbers generated by other formula

D7=Start Date F7=End Date
B13:B31 Data Dates
C13:C31 Data
I need a formula that will count the number of entries  in range

i have a table with 3 columns...column A has the date, column B has the
time, and column C has the # of transactions. how do i sum up the
transactions that occur at the same time.
e.g.

What control how the spreadsheet treats a reference if you copy the
calculation expression?
Here is the question from my book?
    "A reference to a cell in a calculation expression can be either

I need to change names that are in capital letters in an Excel Spreadsheet to
titlecase (eg: HARRY to Harry).

May i know what is wrong with this?
What i am trying to do is to colour the whole row if the date at column
d is a sunday or a public holiday.
I put the following formula in the conditional format, but it doesnt

I have lots of hyperlinks in a worksheet, want to convert them all into plain
text. I couldn´t find an automatic way to do this other than with macros,
does someone have a macro that do this?
Thanks in advance