I need to record the date a particular cell is filled or changed. I was
thinking I could create a formula that would enter the current date whenever
anything is entered into a cell.  For instance when cell A1 has something
entered or changed in it A2 gets the date the cell was ...

How do i add .25 to a column of 15 different numbers at one time instead of
doing it separately.

I've got a series of operations to do on n excel files
the directory is the same..the names of the files are
0001..0002...0003...0004..until 0067
How can I do that through a macro??

What would be the best method of putting whole sheets of data into one
main sheet?
for instance:
Workbook A1:Sheet 1 - has accounting numbers (that is regularly

I need to move part of the contents of a cell (all except the last
chracters) to a different cell leaving the original cell as it was
i.e.
'ab1 2cd' needs to be come 'ab1 2'

Hi i have 2 questions on how to do things if anyone could help it woul
be great. I need to create a text box and a button where when you ente
a number in the text and click the button it mutiplies the number, th
question actually looks like this... a)    Define a variable Mult in  you

I want to calculate each day value, subtract from my total value.
i.e. there are five columns( Mon, Tue, Wed Thu, Fri) and there is one
column (Total) in which is the total value.
I want, when I enter a value in Mon column, it subtract from Total

I have an excel spreadsheet with one cell that needs to be incremented
by 1 every time it prints. So the first printout should read 1 the
second 2 etc.. Any help is appreciated..
Thanks,

Take a column of data. The data in about half the cells of that column are
all hyperlinks. The data in the rest of the column's cells are not
hyperlinks. And needless to say, all the data (cells) are jumbled up.
Is it possible to sort the data alphabetically so that all the

I'm a newbie to Excel and so I'm hoping somebody can explain this
strange feature to me.  When I type the word "cafe" into Excel,
sometimes it reformats the word with an accent over the e (Cafe'), but
other times it leaves the word alone, no accent (Cafe).

when i go to  "save as"  it just shows an hour glass and freezes
does any one know whats wrong???i can not do any work because i need to save
as and send to clients help

Does anyone know how i can change this formula so that i can just dra
it down. I have
=IF(ISERROR(INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(1:1)),ROW(15:15),1)),
",INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1 ...

Help !
This may sound unbelievably silly but I can not sort it out.
I want to type 1-10 in an excel cell but everytime I do that it
converts it to a date. How do I stop this?

I need a little help with what I think is a simply problem, but it is
over my head.
I need a formula that will multiply to cells when an x is placed in
another cell.

I am new at this. I am trying to paste a aparagragh into excel which will be
at the bottom of a form I am making. I am trying to make it in its own box
but it seems it wants to stay in the column that it is pasted into. I would
appreciate any Help.