I have another one for you. I have an inventory sheet I get from a vendor every week. All I need are the columns:
Product Code
QTY in Stock
I would love for them to pull from all 5 sheets and make them one long list. I can't remember how do to that in PowerQuery. I get an updated inventory sheet every week from this vendor, and it takes me time every week to consolidate. Help?
Sheet is here:
https://www.dropbox.com/s/ehpixu3ps6rys18/7-9-18 CTD Inventory Availability Sheet .xls?dl=0
Thanks!
Product Code
QTY in Stock
I would love for them to pull from all 5 sheets and make them one long list. I can't remember how do to that in PowerQuery. I get an updated inventory sheet every week from this vendor, and it takes me time every week to consolidate. Help?
Sheet is here:
https://www.dropbox.com/s/ehpixu3ps6rys18/7-9-18 CTD Inventory Availability Sheet .xls?dl=0
Thanks!