absolute & relative references
 

I am trying to copy an if function. =IF($C$4='April 09'!$B38,"HIT","HOLD").
I want column B to be ablsolute and the row to be relative. However, I am
trying copy and display the results across columns (instead of rows) on a
different sheet. When I copy the formula down it works perfectly....when I
try to go across, it gets compared to Cell B38. Make sense? Any suggestions?

absolute & relative references
 

copy your function down the column as far as you want to go. Select the
cells you just dragged down and select "Copy"

Go to the leftmost of you rdestination cells, right click and select "Paste
Special". There is a check box at the bottom of the Paste Special dialog
that says "Transpose". Check that box and it will copy across instead of
down.

--
HTH

JonR


"zzulu4" wrote:

I am trying to copy an if function. =IF($C$4='April 09'!$B38,"HIT","HOLD").
I want column B to be ablsolute and the row to be relative. However, I am
trying copy and display the results across columns (instead of rows) on a
different sheet. When I copy the formula down it works perfectly....when I
try to go across, it gets compared to Cell B38. Make sense? Any suggestions?

absolute & relative references
 

Perfect! Thank You!

"zzulu4" wrote:

I am trying to copy an if function. =IF($C$4='April 09'!$B38,"HIT","HOLD").
I want column B to be ablsolute and the row to be relative. However, I am
trying copy and display the results across columns (instead of rows) on a
different sheet. When I copy the formula down it works perfectly....when I
try to go across, it gets compared to Cell B38. Make sense? Any suggestions?