Hi experts,
I am stuck on my macro and hoping someone can shed some light on getting my macro to work.
I am trying to build a macro that opens each file in a folder and copy a whole row that has certain data in a certain column.
For instance, when I open first file and if there is a number 148 in its column J, I would like to copy that entire row to my macro sheet.
and I would like to repeat the process until the very last excel file in the folder.
Below is my code.
Thanks much in advance,
Please Login or Register to view this content.
Bookmarks