Copy a row from 3000 excel files stored in a folder and paste it in a new workbook

Awesome! Thank you!

Hi Phil!

Thank you again for the code, works great.

However, i came accross a little setback while using it. The code copies cells incl. formulas in them. Is it possible to copy just values?

I know how to copy and paste values between sheets but I am not able to do that between workbooks. I tried to modify your code to this, but I wasnt successfull.

Could you help me with this as well?

Thank you!!