How do I transpose a worksheet which contains a link to cell refe.

H

Hoochi Coochi Man

Hi
I am trying to link a worksheet to a ne work sheet but with rows and columns
transposed. Problem is that the worksheet contains cellreferences not data so
how can I protect them when they get transposed?
I want the 2 shhets to be linked so the second one updates with every new
row of data in the original (weeky sales figures)
Any ideas woill be very welcome!
Thanks
 
K

Ken Wright

Select your range of data and do Edit / replace / Replace = with [
Now copy the range and paste special / transpose wherever you want it to go.
Select the pasted range and do Edit / replace / Replace [ with =
 
Top