Most valuable professional
  • Hot Topics

Excel Copy Data from several workbooks in same folder containing "Debtors"

I have attempted to write code to copy data from sheets(3) (this is a Pivot Table) in Columns A:F called from all workbooks containing "South End Debtors.xlsm, Conti Debtors.xlsm etc" in folder C:\Debtors When runig the macro, I do not get any eeror messages, but no data is being copied into sheet1 in the destination workbook containing the macro It would be appreciated if someone could kindly assist me Code: Sub Op Dim Dim Dim Dim Dim App Set Set For

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of June 3, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel