Macro Help

[paolettic]

Newer to macro/VBA...

Need a macro to pull data from "Log" sheet from all workbooks in a specific folder

 

[jkpieterse]

Which version of Excel?
If 2016, 2019 or 365, check out Data, New Query (or "Get Data", depends on exact version), From File, From Folder.

 

[paolettic]

365 version from folder

 

[paolettic]

Looking to extract data from each sheet named Log in each workbook, fields A1 to k1000

 

[jkpieterse]

No macro needed, check out my first post.