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
- [libreoffice-users] Simple address data and 3 sheets · Marc Paré
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.