I have loaded and converted over 300 text files in power query Excel 2016. Now I have about 1M lines that I am trying to do an aggregation on sum and count based on 2 criterias. I am running into some performance issues, it shows that my file is loading data for the last half hour but...
I am at a loss for how to do this. My current code is simple and displays data only for the latest checked box:
Private Sub ComboBox1_Change()
Private Sub CheckBox1_Change()
Me.ListBox1.RowSource = "Sheet2!A22:A32"
Private Sub CheckBox2_Change()
I have several workbooks in a folder. Each has a transaction worksheet and a summary worksheet. The number of rows of data in each summary sheet differ from workbook to workbook but all fall within a dynamic range having the name "AData". I would like to consolidate those summary records into a...