Would like a macro that will do the following:
- Go into a specified folder (ie. C:\data) which contains multiple workbooks
- search each workbook for a column titled SCIN
- copy the cell labelled SCIN and 60 cells below it to a new workbook (summary workbook)
- repeat the process in all the workbooks until all of the SCIN columns have been located and copied into the summary workbook
Bookmarks