Posted by David Campbell on August 02, 2001 8:11 AM
I have a spreadsheet that has data arranged with columns and rows one way to make the entry and editing of information easier, and am trying to make a linked sheet with that information transposed to make it easier to gleen usful information. I have tried copy and pasting special links into a second sheet then copying and pasting special formulas transpose into a third, but in the third the links are not transposed, they are just like the first sheet. What am I doing wrong? I have no use for the second sheet except as an intermedeary step to produce the third since Excel dosn't seem to want to let me copy, paste special, transpose and paste link at the same time. I am using Excel 97.