Forum Discussion
johnsonthermalmike
Mar 19, 2021Copper Contributor
Help Extracting Data From Excel Workbooks
Hi, I'm an excel amateur and have task I need help accomplishing some advice. My company uses an excel workbook to produce custom quotes for our clients. Each workbook individually is saved...
erol sinan zorlu
Mar 19, 2021Iron Contributor
Best way is to use Power Query, you can easily get all the data from all the workbook located in the same folder, transform data as you like and create a combined table which can be used for creating pivot tables and graphics.