Inventory Data Management Through Automation
Preparation and Setup
Tools used for automation: Excel, Power Query, & M CodeCreated two folders, respectively for Inventory Data and the Consolidated Data
Contents of the Inventory Folder:
Loading the data
I created a new Excel workbook and saved...
excel-guides.hashnode.dev2 min read