That puts the PST, etc., into the droplist.
Next, the B5 picker cell droplist is populated by going to Data>Validity then selecting Cell Range and entering TimeZoneTitles. (You might be able to use OFFSET to do this from TimeZones, but let’s keep it simple and just create another Named Range.) Then the time zone names have also been selected and turned into a Named Range, TimeZoneTitles, even though it is part of the whole table. Notice that here the entire table of time zone names and relative number values has been selected and turned into a Named Range, TimeZones (don’t use just Zones for quirky reasons, it seems).
Modern folks might do it a little differently.
0 kommentar(er)
