YHRD Excel Import Utility

A utility to import YHRD data into an Excel spreadsheet

Download yhrd.xls
For best results save this file and run from your computer.

This utility has had minimal testing with Internet Explorer, Firefox,
and Netscape browsers but seems to work OK with them.
It does not work with Opera.

In Excel select [Tools][Macro][Macros] and select the 'YHRD_Import' macro
and press the 'Run' button to display the initial YHRD_Import macro screen:

The YHRD screen after searching a haplotype and displaying results.
The entire page is selected by CTRL-A and copied to the clipboard by CTRL-C.

The YHRD_Import screen after pasting the clipboard to the textbox, CTRL-V.
Note that the new worksheet name must be entered.

After pressing "Process Data", the uninteresting text is removed, a
new worksheet is created and filled in with the processed data.