Forum Discussion
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...
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.