I have 2 different list in different sheets, First list has Headings are
CR,WR,Type Second list is CR,WR.
List Values as follows; First list in sheet 1
CR    WR    TYPE

i have worksheet with the following format
1111 abc
1111 xyz
1111 x12

How can I create a link from one worksheet to another worksheet where I have
created check boxes to define the condition, being "good" "fair" "poor" or
"bad"
I think I need to use an "IF" statement.

I am looking for help in setting up a spreadsheet of some sorts to use at a
car show.
The participants of the show have judging forms, they write down a car
number for each of the 28 classes in the show that they are voting for and

Hello,
I am trying to create an equation that would automatically pick up the last
known data point in a range. For example, I have all the months starting from
Row 3 Column C, and in Row 3 Column 1, I need to create a function that would

need help with this function, formt
=ara(x,y,value) etc etc

I am using Excel 2003 and have a table where the bottom number shows an
average of the rows above.  I want to conditionally format the numbers
that are below the average as it changes.
Is there something that I can put in the cells containing the values

I am trying to do a simple lookup in one range of cells that contain numbers
1-9 and return a result from the cell that is next to it.

like 400 will display "four hundred"

In Excel 2003 I have set up a workbook with multiple worksheets (one
worksheet per employee/week) that sums rows and columns. What I have been
trying to do is have all of the sums from all of the worksheets read on
another worksheet. I want to end up with a totals total page ...

I would like to fix the row 1,2,3 for title, and when I scroll up / down,
then title is still there without affected by page up / down.
Does anyone know how to set the row for title to be fixed during scrolling?
Thank you

I have six columns next to each other and am trying to add date based on the
month in every other column.
M8      N8      O8     P8      Q8     R8
$200  April   $100   May   $100   April

This is a wonderful forum, and i need help from excel xperts here. :)
THIS IS HOW MY SHEET LOOKS LIKE
'[image: http://images6.theimagehosting.com/sheet.681.JPG]'
(http://www.theimagehosting.com)

When a value is entered into a cell, you can move to the cell beneath it and
start to type the same value. Excel will recognize the value being similar
and populate the new cell with the old value. However, I find there is no
consistancy with it. Some values it works with and ...

Can anybody please tell me how I extract data that matches the following:
Need to extract the sum of sales that are in a column that matches certain
criteria.
I have a column with products that are sold by certain companys.  Some sell