In general excel formula's do not "drop into" they "get from"

So,
On sheet 5
in the cell where you would like to see the result from sheet 4,
enter the = sign
click onto sheet 4 cell and push enter.

You can extend the formula on sheet 5.
Click onto the right hand bottom corner of the cell....
the mouse pointer will have changed to a + sign....
and drag down as far as necessary.


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=472760