I need a little help. I have created an interactive spreadsheet in excel. I
am using combo boxes to expedite data entry. The lists for these boxes
reside in other workbooks. The problem that I am having is that the other
workbooks have to be open in order for the lists to populate in the combo
box. Is there any way to get around this? I do not want users to have open
both workbooks in order to do the work in one.