Forum

No, Was just a bug, my fault. Change this: Col = Me.Cells.Find("*", Me.Cells(1), , , xlByColumns, xlPrevious).Column + 1 to: Col = Dest...

Hi ER, Here is the revised code: Option Explicit Sub ReorganizeData() Dim i As Long, CellAddress As String, AddressList As String, Result As...

I'll have to see the updated file to understand what happened, please send it if possible.

Hi Mike, In the More Sort Options, there is another button: More Options 🙂 Use this button, and you will be able to pick the column where you w...

Hi Mike, Here is a detailed article that explains the differences: differences-between-olap-and-non-olap-pivottables-in-excel Calculated Fields an...

Hi Mike, Please provide a sample file so I can see your structure, there is no generic code that can detect your layout, there are so many possible...

Hi Mike, A sample file will clarify many things, it will be very helpful if you can upload a simplified file, with just a few rows of data. I an...

Hi Andrew, Is there an error message or the pivot tables are just showing no data? When you refresh a power pivot table, the connections are ref...

As written in code already, the code calculates the number of blocks with data and divides this number by 3, to distribute the blocks, the code writes...

Sorry, forgot to mention that the code should be copied into sheet1 module, not in a regular module. "Me" keyword can only be used inside a workshe...

Hi Bax, Atached is a query made from a folder with your 3 sample files. In CombinedFiles query, in "Expanded Table Column1" step, there are 3 co...

Not sure what you mean. Even if you add a new column and use Excel.Workbook([Content]), 2 columns will show up after you expand the new column: Nam...

Hi ER, You can try this code, after you add a new sheet named Sheet2, the data for printing will be transferred there: Option Explicit Sub Re...

Hi Olayinka, Welcome to our forum! Are you referring to the error from Dashboard sheet cell D6- =GETPIVOTDATA("Sum of No of Active Users (Visits...

Hi Bax, You can try adding a query for a single workbook, process it as you need, then transform this query into a function by simply adding this l...