Option Buttons with macro and working with 2 workbooks
 

I am trying to create a macro that would take a list from one worksheet and
insert corresponding rows in another sheet. Each line would start with an
option button. How should I accomplish this and what do I need to do to
resize the group box according to the number of rows of data that I would
have?

I also want to have a macro that will take a fe values from this workbook
and append them to the end of a list of data in another index file. What
would be the best way to reference the other file if I intend to put the
index file on a shared drive accessible by multiple users?