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

At 08:33 16/12/2011 -0500, Dotty Person With No Name wrote:
> 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!
>
> Both Sheet 1 and Sheet 2 are needed.

That's debatable.  As many people do, you have told us only a small 
part of your problem.  You have designed a solution to your overall 
need which then requires something that you acknowledge to be 
problematic.  The solution may be to design your solution differently 
in the first place.

> Sheet 1 is the input form for all the data that will show up on other Sheets.

No-one can yet know why (or even if) you need those extra 
sheets.  No-one can know why the act of inserting a row in your input 
sheet needs to cause a new row to appear in other sheets.  It may 
well be that you could inherit the data in some other way - perhaps 
using VLOOKUP() or similar.  Or it may be (as I hinted) that you can 
derive the results you need directly from the first sheet, without 
creating all those copies.  Anyone trying to help you needs to know 
what those results need to be before they can help.

> Perhaps I misunderstand what you mean?

I think the problem is the other way about: although readers will 
understand what you want from what you said, they cannot understand 
what you *need*.

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