paste link and transpose

[nowfalapm]

Dear sir,
I wanted to paste link and transpose from one sheet to another, data is in sheet named FCY row E2:E65 and i wanted to paste link and transpose to sheet named FCYRECORD , to column B3:FI 3, Hope somebody will help in this regard.

Thanks and regards
NOWFAL

[shg]

Paste Link and Transpose are not compatible; can't do it.

You could write a formula: =TRANSPOSE(FCY!E2:E65)