VBA code for Looping through files and copying specific data to one file

  • Hi,
    I am new to VBA and If anyone can help, I'd greatly appreciate it. I just need help in simple VBA loop in following code.
    I am trying to loop through excel files in a folder and copy specific data from DispForm Worksheet in all files to a new workbook (sheet 2). I have a code which does 50% of the job but I am having difficulty in picking some data and copying it in specific format. Following image shows the Dispform worksheets and format in which data needs to be copied



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!