Re: [libreoffice-users] Cell reference that updates all sheets?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



On 12/16/2011 03:49 AM, Brian Barker wrote:
> At 11:16 15/12/2011 -0500, Dotty Person With No Name wrote:
> > I have 2 sheets in the same file. Sheet 1 has the primary information
in it that must be reflected in Sheet 2. There are a varying amount of
lines in Sheet 1.
> > When the cell contents of Sheet 1 change I want the cell contents of
Sheet 2 to change.....even to reflect the inserting of new rows in Sheet
1. That is; if Sheet 1 has 10 rows then Sheet 2 will have 10 rows. If I
insert a row in Sheet 1 and put some data into it then Sheet 2 must
immediately update and reflect what is in Sheet 1 including the new row
> > and its data.
> >
> > How do I do it?
>
> Easy:
> o Amend all references to Sheet 2 everywhere in your spreadsheet to
refer to Sheet 1 instead.
> o Delete Sheet 2.
> o Bingo!
>
> I trust this helps.
>
> Brian Barker
Both Sheet 1 and Sheet 2 are needed.  Sheet 1 is the input form for all
the data that will show up on other Sheets.  Perhaps I misunderstand
what you mean?



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJO60iUAAoJEPBpZNn4grcjpRMH/1NF8IuozkjI4gccsc6t8WlU
hhBwbQEZhZ8A8Pk/GCAcXWVdETVqxALx2nPUbf9wPl8M19iDUE9kowqFW57GLsMx
Z8OEx4/vucNuROIxI7qyTcpWPADLhUK5d18Dv798UxmPjPZZP212HoRDPOeAK5to
YIhFaaBP9r7tb4AvpcRb9GxCRDeVVlqOqwMbwLP+HM7DIznglC3FZjEX8kWZRYpc
K4YPnaoeuofH/8lvI9Et59dkCXSgqGHhDszq1CautmZK929Ekgz9ap8nRk9mDy0J
DnR3GCQyJRYKvpKITRA8eT2jG2gr4kbh/tf3g8TJ12PUO/L1VJxA+txS6lF8/z0=
=2qAv
-----END PGP SIGNATURE-----


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted