I currently have a model which really consists of two
workbooks. One workbook is the data input workbook in
which all the data is entered by one person. The second
workbook is used by another person and needs to be able to
import information from the first workbook with a macro.
However, a simple link will not work as I want a macro
that will allow the user to define which workbook to
import the information from as this changes all of the
time. Please help?