Download Morphbank Data Entry Workbook User Manual

Figure 19 Ten New Rows Added to the MyView Worksheet (Only Columns F-J Showing)
Make accessible:
The drop-down menus on other
worksheets use the information in
the auto-generated column (last
column)
on
the
Specimen
(Specimen Description), Locality
(Locality Name) or MyView (View
Name) worksheets to supply
information to other worksheet
drop-down lists. It is necessary to
make the newly generated rows
accessible so the values show up
as drop-down selection options on
the appropriate worksheet.
Figure 20 Top of Page Menu Insert>Name>Define
•
From the top menu choose Insert>Name>Define (Fig.20).
•
In the Define Name window, select the auto-generated column
name from the worksheet where the new rows where generated. If new
rows were added to the Specimen worksheet select SpecimenDescription.
If new rows were added to the Locality worksheet select LocalityName. If
new rows were added to the MyView worksheet select ViewName (Fig 21)
.
33