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

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


--
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