Hey Trevor,
I think that what you have described is pretty much what Joe Conner
mentioned... which is to copy the first cell into all the other cells
and what will happen is you will essentially end up with a block of
links back to the original, which pretty much does what I was looking for.
Thanks.
Trevor Farlow wrote:
Arjun wrote:
Actually I was trying to copy from the source range to a new target
range starting at the current cell, as opposed to putting all the cells
into a single cell. I was under the distinct impression there is a way
to do this. Or is there a rule of sorts that a given cell in a
spreadsheet cannot cause any changes to other cells (as in, the cell
cannot actively do something to change another cell... the only way is
if the other cell refers to this cell somehow).
I can't address whether a rule exists, but I played a bit in Calc just
now and I think this does what you're after:
Set the first cell to reference the top left corner of the range, e.g.
=Prices.A5
then grab the little black square at the bottom right of the cell and
drag it down the column to A10. Then select the range A5:A10 and drag
the little black square across to column G.
Not sure that's what you're looking for, but either way, I just learned
something new.
--
Trevor
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
