Is it possible to automatically insert a blank row after a change in a cell
value

I have the following formula that works fine:
=IF(ISBLANK($F10),"",IF(MONTH($F10)=MONTH(K$6),IF(YEAR($F10)=YEAR(K$6),
$E10,"")))
However, at the appropriate times when the IF formula is genuinely

Does anyone have any suggestions how to select the value?
I would like to retrieve the value within (), such as
2.532 (2.7%) in cell A1
It should return 2.7% in cell B1.

Scenario:
A1 value is "3/31/08"
In column C15, I type the formula, '="For the month ending "&A1'.  
Problem:

I have an Excel workbook that I need to make available to others in my
workplace to view, but restrict their ability to fiddle with it - i.e make
changes, email or print it.  I have password protected the sheets to disallow
editting, but can't find a ready-made option to restrict ...

I am trying to write a macro using VBA that prompts the user to make a
filename selection in order to make the necessary changes to each workbook.  
The same macro will be run on each workbook.

Hi folks, I have posted this problem in the Word group without
success, and also in the Mr Excel bulletin board, also without finding
a solution. I wonder if anyone here can help:
I do regular mail merges in Word using data created in Excel. I am

Hello.  I am fairly new at Excel.  I have made a spreadsheet with 500 entries
(4 fields each).  I see there are some duplicates.  Is these an easy way to
find duplicates, or remove duplicates?
Thanks

I doubleclick the shortcut on my desktop to open an Excel file. It loads
Excel 2007. I did not order 2007. I use the 2003 version. How do I get rid of
2007?

Hi All --
I am using a SumProduct formula that is VERY LONG due to the number of items
I need to verify. Too long actually for Excel to handle.
Could someone educate me on some additional ways to use SumProduct that

I'm using the following sumproduct:
=SUMPRODUCT(--(Costs!$F$12:$F$57=$B7),--(MONTH(Costs!$H$12:$H$57)=1),Costs!$J$12:$J$57)
Costs!H12:H57 is a list of dates - on occassion this may be blank but there
still be a value in the Costs!J12:J57 column. For some reason, if the date

I have Excel 2003  & Visual Basic 6.3 which I can launch via ALT+F11.
First,  I couldn't find VB 6.3 in any of my Program Lists or my hard drive -
where is this program located ? Can this program be launched outside of Excel
?

How can I copy a formula that contains time HH/MM
formula calculates hours emp worked.
just need to copy it to another page without showing value.

Can anyone suggest some questions that might be asked on an Excel assessment
test given by a staffing agency?

The Time stamp data that comes to me is in this format hh:mm:ssAM,  and to
use the data I need to put a space between the seconds and AM (or PM).  Doing
this manually is grueling so I recorded a macro but the macro changes the
data to the data in the cell in which it was recorded ...