I have a column that needs to be populated with either
a "B" or "C" based on conditional logic using an IF
function.  
Column A contains text fields and I am searching for any

I have used the following to display the last date the
workbook was saved. This is not working, any ideas.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As
Boolean, Cancel As

I have two columns of information that I'd like to use to create an
array.  Column A tells me what sheet has a particular flag in it.
Column B tells me how many flags are on that sheet.
A B

I have a list of all of are equipment with a price per
hour for that equipment.  Is there a way that I can enter
the equipment number and have the price show up in the
next cell.  I tried a IF(AND(22=10.00),IF(AND(23=10.00),IF

Is there a way to do this?
Hi have a xls work, which i have my last Update to it like this
-|------A------|----B----------
1| Last Update:| 29-01-2004

I need to be able to self calculate totals for the
following headings within a date range (qtr):
GRIEF(E3), PTSD(F3), OTHER(G3), UNDER 18(H3), ADULTS(I3),
SENIORS(J3), Indiv.(K3), Grp(L3), Fam.(M3), Eval(N3),

    A    B    C    D    E    F    G
1    -4    10    10%    20%    30%    40%    50%
2    -3    20    100    200    300    400    500
3    -2    30    200    300    400    500    600

How do I make a certain cell coloured within an if
statement i.e.
if L4<=3
if true: Green

I need implement a function as follows:
some specific colors is defined with specific meanings.
for example, all blue cells means "earning"
and one cell will sum all blue cells's  value.

In excel 97...
I have a worksheet with about 1000 unique names (column a), each with a
unique number in a seperate column (column b). Is there a quick way to
associate name and number so when the name is used in another column

I have been importing data from one excel worksheet to the
next. For the last two months, that data seems to be
importing wrong. For instance, data from a group will
import into the group next on the list instead of the

In Sheet1 I have data in data in cells:
A1 B1 C1
A2 B2 C2
A3 B2 C3

How can I protect a spreedsheet and leave a selected
range of cells to be unprotected/unlocked? Essentially,
there a number of cells which we need to update
periodically. Aside from that we don't want anyone to

I have the excel sheet which has two sheets
first one has employee number ,The second one has employee
number,DOB,Salary,Address and all the records have some
values for each employee number

May I ask how can I change the size of some cells, let say
changin the width of A1 cell without affecting the one
below it (A2).
Or if that's not feasible.