Hi,
I am in urgent need of help, and hope that you are able to help me.
I need a macro to go to a folder (the folder path is specified in a specific cell (A5 in sheet1)), open each file in that folder, check if cell A15 has data, if not, to skip that file and go to the next file. If cell A15 does have data, then to copy all the data from A15 to column L and to the bottom of the data, to Sheet2 in the current active workbook/file. Once the data has been copied, it should then go to the next file, and check cell A15 again, and copy the data if there is any, but to the bottom of any data already copied in Sheet2.
I hope that you are able to help, as currently this process is taking me about 3/4 hours to complete, and I'm having to do it on a weekly basis.
Many many thanks in advance
I am in urgent need of help, and hope that you are able to help me.
I need a macro to go to a folder (the folder path is specified in a specific cell (A5 in sheet1)), open each file in that folder, check if cell A15 has data, if not, to skip that file and go to the next file. If cell A15 does have data, then to copy all the data from A15 to column L and to the bottom of the data, to Sheet2 in the current active workbook/file. Once the data has been copied, it should then go to the next file, and check cell A15 again, and copy the data if there is any, but to the bottom of any data already copied in Sheet2.
I hope that you are able to help, as currently this process is taking me about 3/4 hours to complete, and I'm having to do it on a weekly basis.
Many many thanks in advance