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+h...@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