Hi can any one help me on this
In sheet1 we have the data
Date    Task name Remarks   
9/15/2005    Incoming    OK

Greetings.  Is there a way you can activate a macro through a formula.  
Example:
=if(A1=B1,(macro here),"")?  Thanks in advance.

I'm having trouble making a subroutine run upon a change to the value in cell
B2. This is the code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "B2" Then

I need to convert regular time to decimal time.  example regular time in A1
is 1:38 I need that number to be converted to decimal time = to 13:63.  add
12 to the hour and divide 38 into 60 to get the minutes.  Our time clock
prints on a 12 hour basis and I enter to excel in ...

How I edit a password protected exel spreadsheet without the password?

I am trying to figure out how to take the contents of cells which are
across a few columns and move them all into one long column.
Example:

I am doing a mail merge from an excel workbook to a word document (letter).  
The first one worked fine, when I activated the next worksheet, it wouldn't
merge the correct worksheet, it does the original one over and over.  ?????

Is the pivot table still limited to 8000 elements in Excel 2003?
Gilles

I guess I am not being clear as to what I want to do.  I take each card and
enter the times in and out into excel for the whole week for each day.  I
need each cell that I enter the time into to be converted to military time
for the hours and the minutes are divided by 60 to get ...

I have one Row that houses numbers 80-90 in seperate cells (11 columns A20:
K20) - these are my Numeric Labels.
I then have several other Rows that span the same number of columns as the
Numeric Labels (A21:K100) and house Numeric Values that relate to the Numeric

I need to autosum all cells that have been marked "x"

I am trying to figure out how to remove a space between two words in on
cell.
ex: dog house ---- doghouse
Once I figure that out I want it to look through a lot of cells and i

if # of years employed is in C5, salary is in D5, percent to contribute is in
D2...I need a formula that determines...IF number of years employed is
greater than or equal to one then the contribution is equal to the percent
multiplied by the salary; otherwise the contribution is ...

When a cell is 28.32, I need it to round to the nearest 0.5, so for example,
this one should equal 28.50.  I tried MRound and Roundup and couldn't get it
to work.
Thanks

I am trying to find a formula to calculate a date in the future. Let me
explain what I mean.... I work for a radio station and I have to form a
prize database. Listeners are only aloud to win once every ninety days.
I have 10 columns that have unfilled dates since a date will only ...