I am trying to copy specific cells from excel and dump into a worksheet. The macro would open, read those specific cells and dumb the cell content in a worksheet. This would be a loop for all files that exist in a directory.
Any suggestions or help would be appreciated. I thank you for your time in advance