Think through what "relative" reference means. (Sometimes I think it's
easier to see relative vs. absolute references in R1C1 notation). When
you copy across a row like that, relative references will change the
column and not the row in each reference. To get it to look in the
same column but different rows, you would copy down the column. Here's
what I would do:

1) Make the column reference absolute ($H15)
2) Copy down three rows (assuming you have four blank rows below)
3) Select the three copied rows
4) Select the cell to the right of the original cell
5) Edit - Paste Special - check Transpose
6) It should give you the result you're looking for.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=377777