I have a workbook that contains currency exchange(currency worksheet)
in one sheet and my working sheet (sheet1). The "currency worksheet"
is layed out like this.

Column A - Date
Column B - US exchange
Column C - Arrow (up or down depending on previous day)
Column D - Yen
Column E - Arrow
and so on. This is all updated daily.

"sheet1" is layed out like this

A3 - US$ B3 - I want the actual value depending on "currency
worksheet"
A4 - Yen
A5 - Euro
and so on.

so in a3, that contains the text "US$", in b3 I would like to link the
"currency worksheet" where I would enter the data given to me. I would
like the US exchange rate and the arrow from colums B and C in the
"currency worksheet" to be pasted in b3 and c3 of "sheet1" and columns
C and D from teh "currency worksheet" to appear in b4 and c4 of
"sheet1"

I hope this makes sense and somebody can help me

Thanks