Forum

Try: Dim TBarray(1 To 10) As OLEObject Dim i As Integer For i = 1 To 2 If ActiveSheet.OLEObjects("CheckBox" & i).Object.Value = True Then ...

Hi Rob, You have to aggregate the source data using Power Query, the output should be a pivot table/chart. PQ:Organizing the pivot table according ...

Hi Farah, PQ cannot split the result of a query into multiple sheets. You can try loading all data in a single table, then create a pivot table,...

Hi Ken, Here are some information that will clarify the problem: Losing Conditional Formatting on Slicer refresh Pivot Chart Formatting Chang...

Hi Luis, See attached example. Most common problem is when you want to store data into a structure designed for visual purposes. "Eye friendl...

Hi Duong, Never seen this problem unfortunately. Can you go to Pivot table ribbon tab and check the pivot source?

You can try this solution.

Hi Hanan, First you have to combine files from folder in a flexible way that will not break when you add new files or new sheets in the source folder...

Hi David, Can you please provide a sample file that replicates this problem?

Hi Matthias, If you just want to write the times: Sub dd() Dim StartTime As Date, StopTime As Date, Seconds As Double Dim ws As Worksheet Di...

Hi Sheila, Welcome to our forum. Nothing attached, please try to attach again (there is a Start Upload button to finish upload)

Hi Wayne, You should use Get Data> From File> From Folder, then you can filter for a specific file extension-.pdf in your case. Example at...

Hi Robert, Here is a UDF function for linear interpolation I created a while ago: Option Explicit Function Interpolate(Y As Double, Tbl As R...

Here is a version that generates numbers using Number.RandomBetween. After numbers are generated, there is a new step that checks the generated ID'...

Instead of trying to generate a specific id in a predefined structure, why not using Text.NewGuid() function? GUID Wiki Attached is a demo for a...