Can I lock a condition alone in a cell so that the cell still can be modified
Example
in A1 I have a drop down list (select A, B ,C)  
n B1 I have IF(A1="A","Ape",IF*(A1="B", "Banana",if(C1="","")))

I have a long database, 27k with names that I want to mail to.  The
list is last name, first name.  I want to do a global change to first
name, last name.  I also want to add "Mr" to it.  For example:  the
list now is Smith, John.  I want to change it to Mr. John Smith for

I can't enter text or numbers into any of the cells on my worksheet.  Can
anyone help?? I know it can't be this difficult!!!@

I've been looking for a soultion for my issue for some time now and was
very happy to find the following resolution posted a little over a year
ago.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)

I tried Tushar Mehta's approach to creating dynamic charts, and it
seems to work perfectly.  However, when I go to save the Excel
spreadsheet, I get this error: "Your formula contains an invalid
external reference to a worksheet.  Verify that the path, workbook, and

I hope everyone is well today.  I am in a pickle and need some help.
My boss has given me a spreadsheet, which was given to him by his boss.
Basically, I need to figure out how the information flows between the
different tabs (12 or so in total).  I have figured out where most of

I am currently trying to create a function that searches through an
array for two exact column values which allows me to retrieve a third
column value.  For example:
Type of Fruit           Date Packaged             Amount of Fruit

Can I copy and paste data in a way that the column width/row height is also
copied? If so, how?
Sincerely
Steven Shelton

I have to create a macro for an excel sheet
I have:
column A - a string (AA-001-06, for example)
column B - empty

My task is to generate a list of all "6 value combinations"
that total a collection of specific sums.
Simple Example: All "2 value combinations" that, when added, =13
List: D701:D709, filled with 1,2,3,4,5,6,7,8,9

Average has what seems to be an odd (inconsistant) behavior to me.  I want
to be able to have a value of "" within the average function arguments, and
for it to still return a result.
For instance, if i have a cell with value 1 in it, and a cell with the

I need to display a value to the users and when the users selects a
display value, I need to save a different code value to the file.  In a
spreadsheet, the user will select frequency.  I want to display text
for the code value.

i have an templet on an excel sheet having complex calculation.
i am not able to view the formulas, as the sheet has been proteceted.
is there any way i will be able to view the formulas.
Thanks and best regards,

I need a combo box,  to be filtered by another combo box,
In one I'll have surnames, and in the other names, E.G.
code        Surname        Name
1              Pan               Peter

Is it poss:ible to have a "live" calandar in excel.
Example
If I type 12 dec in column b2 could it highlight a cell in say x2 whic
would be that date, with 13 dec being y2 etc. etc.? Or is there a bette