I am trying to get this to work but am having a few problems.
1. each containing the value of a third cell---not sure what they mean here
2. Finally change the link for the picture to equal the named formula.- not
sure how this is done

I have two sets of employee data.  The first is a download from our payroll
system that gives each employees department number.  The second is a download
of our health insurance billing.  I need to break the health insurance bill
out to the various departments.  The only field ...

Our users at the call center here track their calls via an Excel Sheet. They
may name the Excel sheet whatever they want, and then at the end of each week
they E-Mail the Excel Sheet to me, and I check call volumes, types of calls,
etc...

I need Excel to look in Cell F29 and populate (with one numerical value from
F5:F14) only one of the series of cells H5:H14 dependent on results in F29
falling between ranges set in B5:B14.  I know the fomula needs to reside in
H5:H14, but the rest is over my head.

I used to (with my old computer) be able to type in "Jul 5" as an example,
and have Excel populate the cell with the current year "Jul 1, 07" ie. fill
the year.  With my new computer, it fills this input as "Jul 1, 01"  Any
ideas on how I can get the current year to populate ...

I have a formula that is simply adding two numbers.
A10 is the total addition of A1:A9   A10= 47,307.55
B10 is the total addition of B1:B9   B10= 139.09
Then when I add A10 + B10 = C10   (C10=47441.63) is off by a penny)

Hi! I am trying to enforce selection from a list (Range1) in column D when
the value in column c is equal to "Hello", if the value in column c does not
equal "Hello" I want the user to be able to type in whatever they want in
column D. I have pored through the newsgroup and not ...

I have used the following information to create a tab oder in a form I have
created.  I copied the code to the VBA and it is still not working correctly.
On my form I have 8 fields only that I have unlocked and only these 8 fields
do I want editting possible. Am I doing ...

Example:-
Say headers Week 1 to WeeK 6 in columns A1 to F1.
Column range A2:F7 each cell contains a number (say 1).
Each column is summed individually in row A8:F8 (which is the forecast

Below is the formula I'm using to for one worksheet to match data with a
worksheet in another workbook, if data matches it references to a cell on
that row, if it doesn't it returns false. On the master file when I fill the
below formula down on the first A2:G2 increases while ...

Does anyone know of an add-in that allows you to lock and unlock multiple
worksheets at one time?

Anyone know how to write a command to add common cells across mutiple sheet?
Example: I would like to add the contents of cell D15 form individual sheets
Jan, Feb, Mar, ..... Dec.
Is there a way to set the range across sheets just as is possible across

Excel 2003
I'm trying to run a very simple COUNTIF function, and it's not
working. I have a list in column A of many product numbers. They are
all set as text. Some have alpha characters others are pure numbers

Hi, How do I switch from one worksheet to the next w/o using the mouse?

Is it possible to conditionally format a drawing?  Or some other way that I
can accomplish the below task?
For example, I have a picture of a floor plan embedded within an excel
spreadsheet.  In this floorplan, it has four offices.  Within each office, I