-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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? I've tried the Absolute reference method ($A$1) but that won't allow for the addition of new rows in an additional sheet. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJO6h09AAoJEPBpZNn4grcj5LsH/2aJz/TGRQOVvKReC5AbXbV4 mCBNVbJGMhUcZiR1oxiZlLCnE1EJPfJ5xKSQY3v5QJtQKTOTtBmPzFip9wrgooy2 S1R0hUA7NNrvSzwk4rEu3g8aOzyWp0iCgcKxbkmYIPs/zylh/BJpRON0UlKzc1Wi bPvhcoDDVPKmQ9SXEd2PHqsN4brZOB6fYy8ijlgczwNXH6I1tDBaeqXm0w7/HhRZ gruP14W+j3DePjCiWJL9bGtVKzx1J2EK9+9Pa5tjCKHIoMAp5PiEN2+M9uu7eeEK sfEydsd8uwA1snpibQu4xgwIwmwPkGXN9RMN/CZaMIcZ+RCztCuLb2ySLoGEd2k= =cGgE -----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