Forum

Use the red line in your code: Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Call AddTrendLine MsgBox Target.Name & ", "...

I know it takes an effort to build a sample file, but it's the fastest way to solve a problem, otherwise there will be lot of messages to clarify thin...

Hard to debug without a sample file, lot of wasted time to understand what you're doing there. You are using an event for a pivot table update to c...

There is no image, make sure you press the Start upload button after you press the button to Select files.

Hi Navneet, There is no cell shifting in PQ, but you can perform other operations to join the names for example: Add this step: = Table.AddCo...

Hi Jan, Make sure you reference the sheet properly, instead of ActiveSheet: Set mySeriesCol = ThisWorkbook.Worksheets("A").ChartObjects(1).Chart...

Was answered already on the other forum.

Can you upload a sample file with your codes?

You can use a simple formula in B2, copied down: =IF(C2<0,1-(A2+C2)/A2,0)

Hi Dan, Can you clarify the following case? You have highlighted in red below an overlapping: 10000206 Østerhåbskolen afd. Torsted 1/12/...

You already have a solution in the file you uploaded, an additional column as you have used is not a bad thing. Seems you have the results you want...

List.Distinct is essential, creates unique column names, there cannot be duplicate column names. Most probably what you need should be done in a di...

Hard to see a reason, without a sample file, can you upload one?

See the image attached.

In your example, 500 and 25% is based on range A3:A6, considering cells A3=2000 and A6=1500. Ca you explain the logic that isolates these cells as ...