On 01-01-2014 12:22, IGraham wrote:
Hello and a happy new year
Calc, paste special, transpose and link
I've done this before but can't get it to work again - I'm blaming the brain
cells
In one spreadsheet I select a range of vertical cells and copy
In the second spreadsheet I right click a
How i managed to do it before I've no idea ? - the brain cells must be even
more diminished than i thought
however this worked
=TRANSPOSE(the cells) then press SHIFT CONTROL ENTER
thanks for looking at the problem people and apologies for distracting you
from your new year celebrations
El 2014-01-01 04:42 p.m., IGraham escribió:
How i managed to do it before I've no idea ? - the brain cells must be even
more diminished than i thought
however this worked
=TRANSPOSE(the cells) then press SHIFT CONTROL ENTER
thanks for looking at the problem people and apologies for distracting