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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 =
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to transpose data (Row to column) without losing the cell link 3
Transpose with linked data 6
transpose data 7
how do I link data between worksheets when data is transposed? 3
Transposing a pasted link row into a column 3
Past Special- Transpose Function? 7
how do i transpose a worksheet with formulas and look up tables in 5
Transpose Large Column to Row 2

Back
Top