bringing data from a column to a row in a formula

H

Hulk

I will try to be more specific about my problem.

I have a worksheeet with the data going down a column. On anothe
worksheet i have a formula that needs the above data but thi
worksheets data is in a row.

I tried using the $ sign to keep the column constant, but it won't wor
when i'm using data from the other worksheet. I can paste the info, bu
when the data changes i have to go back and repaste it, and its
hassle. Why won't the $ work across worksheets.

HUL
 
Top