Re: [libreoffice-users] Re: Too many sheets?

Hi :)
Wow!  That really does sound like something that would be better handled by a database.  Plus it 
sounds as though you have already made the most difficult step that most people have with databases 
which is the conceptualisation in your brain.  Most people never get that far.  

Please forgive me my excitement but i just thought this was a heavy and intractable spreadsheet 
issue which i tend to find very, very dull.  

The "Start" sheet would be the table of data.  All the other sheets would be Forms/Reports built up 
from Queries.  Initially people would probably feel more comfortable using the Queries directly as 
they look like a spreadsheet.  Forms&Reports display the same info in a prettier gui so they might 
get built-up later.  Queries are probably easier to work with and are clearer about exactly how 
they choose which data to show from the table.   It's probably easier to modify or tweak Queries if 
things change in the future.  

I take it the information in "Start" is confidential?  Is it possible for you to let us see the 
formulas of 1 or 2 of the other sheets?  or even just a couple of the formulae from 1 of the sheets 
that reads the data?  This list doesn't handle attachments so either copy and paste a couple 
directly into email/message or use Nabble?  
Regards from
Tom :)


--- On Sat, 25/2/12, PDA1 <peace@aleksandrsolzhenitsyn.net> wrote:

From: PDA1 <peace@aleksandrsolzhenitsyn.net>
Subject: [libreoffice-users] Re: Too many sheets?
To: users@global.libreoffice.org
Date: Saturday, 25 February, 2012, 12:49

Yes, all of the spreadsheets are needed.
  
I have a main sheet named START wherein all of the "data" is entered, such
as names and birth dates.  Then on each of the 35 sheets an array has been
created which shows all of the data that was entered in the sheet named
START.  But....as each sheet is specific to a certain person (and not all
people) only that persons "data" will appear on a given sheet in the cells
that I want them to.

Here's how it appears- Spreadsheet at the top  (starting at A1) (let's call
the sheet CARLTON) wherein all of the information from the sheet START
appears.  Below that spreadsheet CARLTON with all of the data is an array
that shows ALL of the data from the sheet START.  CARLTON has cells with
formulas that get the necessary information/data from the array below it.


Does that make any sense?

--
View this message in context: 
http://nabble.documentfoundation.org/Too-many-sheets-tp3769750p3774891.html
Sent from the Users mailing list archive at Nabble.com.

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


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