I think I left something out in my request for help, on the range of cells
that we are throwing out the high and low in regards to the question posted I
need help with range of cells-
I have for example cells d2 - o2 a total of 12 cells, with scores in each.  

i just started using excel so i don't hae a clue what to do. how do i get
data from one work sheet to another worksheet automaticly so when i enter the
data on sheet 1 it gets entered into sheet 2 automaticly?

Hello
I would like to use the contents of cell A16 as my sheet sheet reference and
the current row,colum as the cell.
A16=Sheet1

Hi.
I have two datasets (in two different worksheets) with same labels for the
columns, however, with different list of genes in each row. I am interested
in comparing the values when the gene is present in  both datasets.

How can I restrict entry of positive numbers in a cell using data validation?
In other words I want only to be able to enter numbers that are less than 0.
Thanks.

Can anyone advise how i can autofill a column each time there is an occupied
cell down to the next occupied cell and carry on doing this to the end of the
column? I can obviuosly do it manually but is there a line i can put in a
macro to do this?

I have a workbook with a number of sheets, on each sheet there is three
columns > Date > Amount > Po Number. This vba is supposed to only to look in
column three (Po Number). Po Numbers have six digits. The problem I have with
this

i want to count the number of cells in a column that contain the text string
RDS. however there is also other text in the cells. i've tried
COUNTIF(H4:H108, "RDS"). but it returns 0 presumably as the cells contains
other text. how do i do this ? many thanks in advance.

OK, this is getting on my nerves now, and i'm sure i'm just missing
something really simple!!
I have 3 columns of data

I am needing help; I use spreadsheets entering 6 scores and have to throw out
the high and low and average the remaining 4.  This I can do; BUT if we add 6
more scores to the scenario making a total of 12, is there a way to throw out
3 high and 3 low and average the remaining 6?

I have converted metric into imperial using the convert function which gives
me the result I want, however Excel doesn't write it in this format 11'3"
but rather as 11,3
Is there any way that Excel can show the proper way (11'3") ?

Count Continuous data between cells.
Eg.
Cells
A        B      D     E      F     G    H      I

Does anyone know of an easy way to sum a function over a range of values such
as from k=0 to k=N, where N is a variable in a cell?
Thanks,

Question:
How can i programmatically password protect a single password.
I want the user to be presented with an input box where they are asked to
enter a password.  If the password entered is correct, then go to Sheet 1,

I downloaded a sample file on lookuppictures from McGimpsey and Associates.  
The file gives information regarding looking up and displaying a picture
based on cell value.  I have two questions.
1.  In the file the pictures are named as picture 1, picture 2, etc.  Can we