#1
|
|||
|
|||
Common and Scientific names
Hi, I'm new here and need some help. I need to make a table, in the first column I need a drop down list with common names of trees, in the second column I need the Scientific name to automatically appear. |
#2
|
||||
|
||||
That's not going to happen without a lot of work. For Myrtaceae alone, there are over 900 botanical names. On top of that, multiple trees might share a given common name, some trees are known by more than one botanical name, trees with a given botanical name might have multiple common names, whilst others have no common name.
If that's not a deterrent, you might want to look at: https://www.msofficeforums.com/word-...html#post46287
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
I made up a demo file with repeating content controls and a linked xml file. You can amend the list of trees by taking this back to a single table row and then editing the properties of the combobox Content Control (on the Developer Tab) so the list is as you want it.
This demo makes use of an embedded xml file with an element linked to the two content controls so that if the first one changes, the value appears in the second one. You can add new rows as you need them by clicking on the Plus sign that appears at the end of a row when you select something in that row. You can also right click on a row to add or remove a row. Note that this will not work in Word 2010 or earlier - it uses a feature introduced in Word 2013. Whilst I used a macro to create the embedded xml file, it is not needed in operating the file so it isn't included in this example. The actual list you use could be enormously long although I would think there would be some level of pragmatism applied. I would expect that you don't really need to include in the list 'every' tree's common and scientific names. It is more realistic to expect the OP's list to include only the tree types endemic to the location, that the author actually can identify, and can remember the common name of.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to share task common to 2 projects? | Michele | Project | 1 | 01-05-2016 06:29 AM |
Common Document template for all projects | ch1253 | Office | 1 | 11-15-2014 04:43 AM |
How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |
Need help with sorting a column by most common to least common | mikenmike0001 | Excel | 5 | 12-06-2011 05:17 PM |
Common mailbox analyzer/statistics | NoStr0m0 | Outlook | 3 | 09-23-2011 05:22 AM |