Hi, I have couple hundred .xls files in a folder and in each excel file, at column AW5 has value 1, 3, 4, 5.
What I need to do is the following:
1. Go to each .xls file
2. Go to column AW5
3. At the active current blank sheet, make a list of files at Column A that has value 1 at the 5th row and value 3 at the last row of the column
4. Make a list of files at Column B that has value 1 at the 5th row and value 4 at the last row of the column
5. Make a list of files at Column C that has value 1 at the 5th row and value 5 at the last row of the column
Can anyone help to suggest how to use macro to do the steps above? Thx ahead.
What I need to do is the following:
1. Go to each .xls file
2. Go to column AW5
3. At the active current blank sheet, make a list of files at Column A that has value 1 at the 5th row and value 3 at the last row of the column
4. Make a list of files at Column B that has value 1 at the 5th row and value 4 at the last row of the column
5. Make a list of files at Column C that has value 1 at the 5th row and value 5 at the last row of the column
Can anyone help to suggest how to use macro to do the steps above? Thx ahead.