Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


I am trying to keep a spreadsheet file as simple as possible for a group of musicians who have very little to no knowledge of how a spreadsheet functions.

So, in the spreadsheet, I have:

* Sheet1: has a list of names, in a column, that will change monthly describing how long each musician played in a second column. A musician "general manager" would input the musicians names once a month. This list would change every month and would have different combinations of names depending on whether they were hired to perform or not.

* Sheet2: has a column where it lists the musicians' names who performed by referencing the corresponding name cells to the Sheet1 name cells, BUT, Sheet2 has to have their addresses show in a set of cells that mimics an address book (similar to Thunderbird address book)

* Sheet3: has ALL the lists of the musicians' names, addresses laid out like an address book similar to Thunderbird (simple to put together for any user)

I was wondering if there was an elegant way of doing the following:

Sheet2 would need to find the corresponding name from each name cell on Sheet1 and then look up the correct name on Sheet3 simple address book. The musicians data in the Sheet3 address book would then fill in the cells on Sheet2

My solution thus far:

* create a series of "if" arguments that would check each name in the name cell in Sheet2 until it finds the same name and then, once the "if" argument is satisfied, would then fetch the address data from Sheet3 simple address book and populate the cells on Sheet2


My question is ... Is there another simpler or more elegant way of accomplishing this process? Is there another argument I could use to do this?

Thanks for the help.

Marc



--
Marc Paré
Marc@MarcPare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


--
To unsubscribe e-mail to: users+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.