Forum Discussion
btillis94
Jul 26, 2021Copper Contributor
Creating a master list from many lists
I have a document with 24 tabs, each has different sales data about products. I want to combine all of these products into one master list, with the duplicates removed. I only want to make the lis...
Riny_van_Eekelen
Jul 27, 2021Platinum Contributor
btillis94 And this is how. (Workbook with PQ attached)
Edit: Uploaded the wrong file initially. Then realized that it connected to a file on my own system. Better to upload the M-code that you can paste into the Advanced Editor. Can't add it here, so refer to my next post. Just change the path name to the file.