Hello,

I need a to loop through all excel files in a specified folder and copy the last column of data to a destination worksheet. Can someone please help me with the code for this, i do not even know where to start.

Thanks