I am trying to loop thorough and Excel, the process infromation as followings:
- Open an Excel file and pull the data from cell C3, this data will be used to open a subsequent Excel (CSV) file. i.e. the data in cell C3 is the name of the Excel (CSV) file that needs to be opened
- Once that Excel (CSV) file is opened, use the data in E3 to filter the data in the Excel (CSV) file
- Take that filtered data and write it into a new Excel file
Repeat these steps, except data will be pulled from C4 and E4 respectively, C5 and E5, C6 and E6…such on and so forth.
I need this to occur until the end of the column is reached
Thank you for your help