Umang C Bhatt 24.Aug.10 02:01 AM a Web browser 1-2-3All ReleasesAll Platforms
I am using smartsuite version 9.6. I have observed that what Range Transpose command primarily does is to copy row contents in column and vice versa. While transposing I observed that it pastes the cell format also. This prompts me to ask a question that is it possible to do a Paste-link ? I want to use Range Transpose in 3D range. If this is possible than if we make a change in one work sheet than automatically its linked value in other work sheet changes.
For Example
There are foour worksheets grouped together.say
North, West, South and East. The fifth worksheet is Total. Now There is a column in fifth worksheet as under
North
West
South
East
values in adjoining column cane be transposed to respective four worksheets after defining 3D range. My problem is to connect them to fifth worksheet. So that when I change a value in fifth worksheet then respective sheet (i.e. one of those which are grouped) value is updated.
Return to top
Print this page
