I have a Macro button which is used every month to do a SAVE AS the problem
is I have to go in the macro every month and change to the current month,
Does any one know of a way to get the macro to change the month.

I have a big problem and need descreptly your help on that.
I have an excel 2000 sheet in which i need to calculate average of time
taken to solve the problem. Sheet details are given below
time is in [h]:mm format and conditions are there i.e. if data in column A

Can someone advise me on how to setup the sum of a formula to be shown as
"Red for negative and/or Green for positive" totals?

Does anyone know a formula that will change a date to 1/04/05 when it is
prior to that date eg. 1/04/04:31/03/05.  It must be able to let through the
dates that fall after 1/04/05 eg. 1/04/05:31/03/06.
I need the same thing again but where the formula only alters the dates that

The ISNA function does not seem to be updating when I put new data in the
cells that the formula is calculating for. The only time it is doing the
update is if I enter into the cell and then press enter...any suggestions?
Thanks!

Is it possible to convert numeric figures in to words?
Examble: if one value is 1,250.00, i wanted it to be converted to other cell
as "One thousand two hundred fifty only." If there is any formula in excel
kindly inform me please.

An option has been pre-set that I am trying to disable.  Every time I drag a
group of cells across, some of the cells are automatically incremented by 1
when all I want is the exact number to drag across.

Is it possible to merge cells on a work sheet that is protected?
Eric

I have a list of work completed over a 24 hour period. I need to filter out
all work completed each hour. I have used autofilter, but at present need to
use this function for every different hour, if i use a macro, the subtotal
changes to the filter I'm inputting. Can i use a ...

I want to have results shown only when I input data.  At the moment the cell
formula is using 0 in place of blank cells to give the wrong answer.  Help

dears,
I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1  will be
present though one hightligted in yellow and another highlighted in green

I have a very basic columnt list which I populate with figures, it should be
simple I know, but I can't seem to find something which shows the last value
in the list.
e.g. The list has a max of 52 entries, which I enter weight figures into,

I have daily worksheets, which are contained in a monthly workbook.  I have
daily numeric totals.  On the end of the month worksheet, I need these daily
numbers (totals) to grand totaled.  At the start of a new month, I begin this
process all over again with fresh worksheets...so ...

Basically have a spreadsheet of info on current jobs.  On sheet 2 i would
like a count of active jobs.
On Sheet 1 data is laid out as follows:
Column A = "a" or blank

I need help understanding the FORECAST function in simple terms (if
possible).  Do I have this straight?
Let's say I have 9 periods of history, and I want to forecast what will
happen in the 10th.  I have the periods listed as numbers (1,2,3...) in