Step 1 GET THE ids

in INTERNET EXPLORER

edit the AUTHORS page

goto CONTENTS field

ctrl-a to highlight all IDS

ctrl-c to COPY all and then

in NOTEPAD

ctrl-v to paste into a empty notepad

ctrl-a to highlight all in NOTEPAD

open WORD

ctrl-v to paste into a empty WORD doc

ctrl-H to find/replace

replace " " (don't type the quotes, just the space) with ^p

ctrl-a to highlight all IDS

ctrl-c to COPY all and then

open NOTEPAD

ctrl-v to paste into a empty notepad

ctrl-a to highlight all IDS

ctrl-c to COPY all and then

OPEN EXCEL

click in cell d-1

ctrl-v to paste into column D

#2 GET THE CORRESPONDING author NAMES

in EDITOR, browse to the AUTHORS page

highlight all the names of the authors

they'll be in the same order as the ids you just got

ctrl-c to COPY all and then

in NOTEPAD

ctrl-v to paste into a empty notepad

ctrl-a to highlight all in NOTEPAD

open WORD

ctrl-v to paste into a empty WORD doc

ctrl-H to find/replace

replace "^p " (don't type the quotes, just the space) with ^p

this changes all the empty lines with spaces to empty lines

replace ^p^p with ^p

this deletes all the empty lines

replace ^p^p

with ^p

this deletes all the empty lines

replace " " with nothing (replace all)

(or however many spaces are at the beginning of a line

now all the Author Names should be on the same number of lines as the IDs

ctrl-a to highlight all names

ctrl-c to COPY all and then

open NOTEPAD (to remove WORD formatting if any)

ctrl-v to paste into a empty notepad

ctrl-a to highlight all NAMES

ctrl-c to COPY all and then

OPEN EXCEL

click in cell f-1

ctrl-v to paste into column F

-- -- -- -- --

into cell c-1 paste <option value="

into cell d-1 paste THE ID

into cell e-1 paste .html">

into cell F-1 paste THE name of the author

into cell G-1 paste </OPTION<

-- -- -- -- --

copy the c-1, e-1, and g-1 cells and paste into each row that needs it.

highlight all the cells c-1...g-1 down until the last row

copy ALL, paste into NOTEPAD

highlight a TAB between the cell data in NOTEPAD,

ctrl-c to copy it

CTRL-H to REPLACE ALL

paste the TAB character in the first field

replace all TABS with nothing.

highlight everything and CTRL-C it to copy it.

This code can now be pasted to the SIDEBAR pulldown between the SELECT TAGS