How do you switch between 2 open workbooks using a macro. Both workbooks
would already be open but I need to be able to pick a value from one, then
look for it in the 2nd workbook and then repeat.

Thanks