G Gulshan Hinduja New Member Nov 18, 2010 #1 Theer is a column if the open workbook which gives the list of workbooks which are to be referred and a range of values to be pased against the specific workbook name
Theer is a column if the open workbook which gives the list of workbooks which are to be referred and a range of values to be pased against the specific workbook name
Hui Excel Ninja Staff member Nov 18, 2010 #2 Have a look at 2 posts over at http://www.dailydoseofexcel.com http://www.dailydoseofexcel.com/archives/2006/01/24/different-approaches-to-retrieve-data-from-underlying-workbooks/ & http://www.dailydoseofexcel.com/archives/2004/12/01/indirect-and-closed-workbooks/
Have a look at 2 posts over at http://www.dailydoseofexcel.com http://www.dailydoseofexcel.com/archives/2006/01/24/different-approaches-to-retrieve-data-from-underlying-workbooks/ & http://www.dailydoseofexcel.com/archives/2004/12/01/indirect-and-closed-workbooks/