I have a spreadsheet that I am making into a template.  It uses paste
links to three other worksheets. Each of the finished templates could be
used in around 20 different folders within our network with the three
linked worksheets being different for each folder.

I know this should be simple but heres the deal. I have an expected
completion amount per day. I have a list of outstanding items in a
column starting from Day 10 + down to day 2.
I need the Expected completion to be taken off the outstanding items

I'm working with an if statement that enters a certain value if th
average is a certain value, but I want to make it so that I can hav
the formula in the cell, but not have it return a value until the othe
fields are in the row have been filled. So I would use some sort of i

Hi, I have upgraded from office 2000 to 2003. Since the upgrade I can no
longer import my textfile into Excel or Outlook, because any carriage return
in a text field (text is marked with "", fields are separated with ;) will be
recognized as end of line / paragraph mark, ...

Trying to sort a column that was dd/mm/yyyy and have since changed t
dd:mm:hh to display days, hours and minutes. The results are all ove
the place and not in descending or ascending order.
Any ideas?

New to using Scenario Manager. I have a worksheet set up that I now must
outline 7 scenarios. Whilst i am able to do each scenario it is possible to
have one scenario summary worksheet showing all 7scenarios or must i have 7
sceanrio worksheets?

One thing that has bothered me for a while is my inability to use times
as an axis label.  Typically I have to convert everything to seconds or
something whether for use on the X- or Y-axis.  I want to know - there
must be a way - how I can have a column or row of times in the ...

Hi there, i'm new so i hope this explaination makes sense.
I'm just doing a practise run with something like a banking record. I was
able to put in formulas that worked except.... in one cell there is a message
that says        " The formula in this cell refers to a range that ...

I have an issue with graph diagrams. Here a sample to illustrate the
situation:
1st row contains date: e.g. April 4 2006, April 7, 2006, April 5 2006
2nd row contains data e.g. 5 Dollar, 4 Dollar, -3 Dollar,

If I ahve a start date & end date, how I can get a  correct difference
bewteen these two days?
For example, "Start Date" is 2006-05-29 and "End Date" is 2006-05-31. It
suppose is 2 days difference. I have used "Days360()" to calculate. The

Is there a way to adjust the column width automatically to fit the length of
the longest data in the cell.  I know how to do it one column at a time but
not how to do all columns of data at once.
Thanks,

Thanks to a suggestion here, I was able to graph out the spaces on
the invoices properly, but I ran into another snag, here's the situation:
I am tryinhg to figure out a way to print invoices from an excell
spreadsheet.

I can select a column and have it auto fit. However when I go to the next
cell in the column and it has more characters I have to again go to auto
fit. Is there a way that the column can be set to automatically auto fit
when the characters are greater?

I have a spreadsheet with many tabs, and am trying to keep things simple for
the end users.  
Is there a way to hyperlink to or create a button w/macro that goes to a
hidden worksheet?

I need to write a formula for the following but am confused as to how to do
it. Can someone help?
1. determine gross pay in column F as follows:
a. In cell F4, enter an IF function that applies the following logic and