I got 2 functions in my Excel func1 and func2 and its running in automatic
mode. Since my excel i s running in automatic mode, both functions are called
again and recalculated.
I would like to avoid recalculating of func1 but would like func2 to

i need to use a formula in which the variable part is the worksheet name, i'm
trying to use INDIRECT($A$1 & "!A2"), where the value of $A$1 is the
worksheet name, but when i copy my formula to the other cells, the A2 part
does not update

The company I work for uses Excel to record meeting minutes, and this then
forms the basis of subsequent meeting minutes. Changes made during each
meeting are manually highlighted by means of a formatting change, such as a
colour change to indicate an added note. This means ...

I would like to optimize shipment sizes by taking both shipment and storage
costs into account.
I would like to use the goal seek function to minimize the value in a
certain cell (total cost) by changing another the value in another cell

I have two seperate spreadsheets, one inventory (A) and one for customer
orders (B). In (A) I have listed product name along with product number. Is
it possible to enter the name of product in spreadsheet (B)
and have the next cell automatically fill in product number from ...

I would like to program an intelligent Vlookup as follows.
I have a set of data spread over 2 columns.  Let us say column A is type of
Food and column B is actual food-item.
for example, here is a short list

I have a spreadsheet that contains rows with multiple entries for the same
item.  How can I use a filter or a function to combine the values for the
like items in to one row?  
Example:

I'm trying to set up a max function with two specific criteria.
In column C I have client Age
In column F I have Employee contribution
Criteria:  If the client is above the age of 50, the max amount they can

This should be simple but I'm on a deadline.  Need to write a formula that
will provide a weighted total.  I think it's an IF statement something like:
IF a1=5 then * 2 (I have a table with the weights so the number 2 would be a
cell reference.  Just not sure of all the commas, ...

I would like to cut and paste pictures in excel 2003 as I did with excel
2002.  It won't let me do that since I have upgraded.
It is more stepes to insert a picture than to cut and paste as before.  Is
this going to be changed?

I tried to post on the original thread but did not seem to work.
Here it is again:
Here's the code that I am actually using (I changed the cell reference A10
to B19).

I have the number 2006 in the format "2 006" in cell A1 and I want cell A2 to
be in the correct format "2006". How do I accomplish this? Thanks!!

I created a special format so that leading 0's in a value are printed.
However when using the CONCATENATE function of excel, the formatting is
ignored and the leading 0's are dropped. It would be valuable (to me) if the
formatting of a cell (number of decimal places, leading ...

I have created a "specil" format for the display of numbers that shows
leading zeros of a value. I then want to use the CONCATENATE function to join
multiple cells with this characteristic. Unfortunately the CONCATENATE
function ignores the leading zero rule I have imposed on the ...

My Numeric Data spans 61 columns and many rows. The Data comprises Numeric
Values and Numeric Labels. The Numeric Labels and Numeric Values are in 2
separate consecutive rows of data, a blank row and then a new set of Numeric
Labels and Values in 2 separate consecutive rows, a blank ...