I would like to create a Macro so that when a cell in column H on a
spreadsheet is edited the contents is checked and changed if it is a
certain value.
Can anybody offer any help as to how I can do this?

My spreadsheet gives a breakdown of employees by their teams within a
business unit; for example, lets say everyone listed in the spreadsheet works
in the U.S. Sales business unit and the teams are named North, South, East,
and West.  The first and last names of all employees on ...

i want set wrap on as default in excel.
what must i do
thank you

i am trying, unsuccessfullty, to sort some data (a small example is below) so
I can graph it. I want to put it into a pivot table format but don't want
calculations, just the actual data. any ideas??/
Location                                   DATE    Result

I have a lengthy sumproduct that relies in part on the following test:
=SUMPRODUCT(--('Standard cost codes'!$E$2:$E$473=E124))
'Standard cost codes'!$E$2:$E$473 is a list of cost code descriptions
in text.

I recorded this macro to copy the data from a particular formatted file to a
normal worksheet.  In order to get it in a normal format (All Testing
Results.xls) in order to import it to my Database Table.  And it worked.  Now
I'm in a process to creat a macro that will automate ...

Am using the code below to count how many times the 'CmdAdd' button is
pressed, when it has reached the target of 6 i would like to save the
workbook into a temporary file, this bit works but i would like the
file name to be the time and date for the save as this would then not

(MS EXCEL 2002, Windows XP)
One of our users has a CSV file, with a date column. The date format in this
column is American, and needs to be in UK style format. We try highlighting
the column and selecting the correct format, but it makes no difference.

I need a way to generate a cell address (row,column) from the value in
another cell and be able to use the contents of that in a calculation.
Here's my situation:
I have a table of mileage readings for my car taken at odd intervals.

How to convert angles (nautical, astronomical,...) and vice versa,  please ?
Example:
187º 12´ 238´´ = 187,266111 º  
¿ como pasar ángulos expresados en grados, minutos y segundos  a grados y viceversa como en el ejemplo ?

Is it possible pass control to a macro in a second workbook that
requires the value of a variable from the first?
The code I have so far is:
Sub CallResultsAnalyser()

I Try to open my files in Excel, but I have message : The document is corrupt
and can't be opened. To try and repair it, use the Open and Repair Command in
the open dialog (File Menu) and select Extract data when prompted.
I'll try n still can't opened..

I have a work book that can have up to 100 sheets within it.
An example of a sheet is:-
Col B    Col F    Col N    Col AM    Col AN    Col AO    Col AP
Test 1    12/03/03    1    01/01/03    31/03/03    01/01/02    31/03/02

Gidday,
I have used a formula to make the days show from the corresponding cells
above.
ie:

If you are printing a long thin spreadsheet, is there anyway to print it so
that it would wrap around and continue printing on the same page?  Instead
of just using the top 10% of several pieces of printed paper.