I have an Excel spreadsheet (called AccList.xls) that has several columns in it. In the 'A' column I have file names for other spreadsheet workbooks; jsmith.xls, fbloggs.xls and so on. In the master workbook (AccList.xls) I want to run a macro that will look down the 'A' column and pickup the next file name and access that workbook, read in some of that data and print it out depending on certain conditions and then move onto the next filename in the next cell down. How do I access another spreadsheets data?
Any help (or any info on good resource sites) greatly appreciated.