I'm trying to hyperkling to another wrksht, display the data within the cell
not wksht name with location.

Can Cntrl-S be added to this script so each time it will save as well?
Thanks for any help...Bob
Private Sub Worksheet_Change(ByVal Target As Range)
   Dim NextRow As Long

I have a excel database that I am using for a pivot table which has an
automated day of the week field in it. I have a formula in Column B for the
day of the week which is worked out by the date in Column A. Formulas I have
tried in Column B have been =if(A1>0,weekday(A1,2),"") ...

I am trying to create a COUNTIF function in 1 worksheet based on multiple
criteria in another worksheet.  Basically, I want to count the number of
cells that the criteria of 3 different columns in a separate worksheet (i.e.
$A:$A="Smith" and $AS:$AS="4/19/2007" and $CL ...

Hello
I have have an array of data A1:G12.  I would like to find the max of A1:A12
and then count the the >0 Cells in B2:G12 where A2:A12= "DOG".  How do I Add
the MAX part to the formula?

Say I have the following
      A    B
1     2     10
2     4       5

The result of a Count(IF . . .) formula is showing in the function arguments
box, but not on the actual worksheet.  How do you resolve this so the formul
result displays on the worksheet.  The formula I used was
=COUNT(IF((A2:A11="South")*(C2:C11="Meat"),D2:D11)).  On the ...

i have retail prices in column I in Exel.  i want to mark up the prices by
10%.  how do i do it?

I have a large # of worksheets where the tab names will change.  I would like
to list them on a separate worksheet that will reflect any changes made to
the worksheet tab.  Is this possible or should I just re-type the list?

I have a list on quintile values for monthly rainfall totals. ie ..
A     B    C    D    E    F    G    H
Quin    0    1    2    3    4    5    6   
Jan    0-0    1-10    11-23    24-58    59-80    81-90    91 and greater

col A1 thru F1 has following codes
1,5,7,8,4,9
Col a2 thru F2 has 10,15,25,50,55,60 values
col G, H & I need a formula where col G would add the value based on code 1

I have a formula (geared towards adding up my project hours) that
reads, =A2-A1*24.  This works fine.  However, in addition, I need it
to also say if the result is zero then it should have a null value.
Is this possible?

I want to be able to go automate after entering data in the last cell in a
row to then go back to the beginning of the next line?

i am weighing coins from a coin-op car wash and i need to sum up all the bays
of the car wash  in a spreadsheet. ex: bay #1 has 10.12lbs of coin and bay#2
has 8.15lbs and bay#3 has 9.11lbs how would i do that?? thanks
im using excel 2003.

I have a large table with a lot of emty rows and to use autofilter I need to
remove all these.