The code then does the same test for the rows in the source range.
The examples described in this article add the data from multiple workbooks to a summary workbook.
The different procedures demonstrate techniques for pasting the data by row or by column.
The company has a folder that contains all invoices, and they want to summarize the invoice data in one workbook. NRow = 1 ' Loop through the list of returned file names For NFile = LBound(Selected Files) To UBound(Selected Files) ' Set File Name to be the current workbook file name to open. Value = File Name ' Set the source range to be A9 through C9. state and restores the value at the end of the subroutine.
The invoices each have a summary box that has information in cells A9 through C9. File Name = Selected Files(NFile) ' Open the current workbook. Open(File Name) ' Set the cell in column A to be the file name. Filtering the Data Another useful example in the de Bruin article is a sample that uses a filter.
Additionally, you will see how to retrieve data by using a filter.