Forum

Try attaching here once again. Your link could not be found when I clicked on it.

Maybe this is what you are looking to do

With Power Query. The hard coded filters could be parameter queries if you are looking for more variables in your lookups. let Source = Excel.Curr...

Here are some potential reasons you may be having difficulties. This listing is not exclusive as there may be more issues. 1. Dynamic Content &...

Cannot replicate your issue. When I place the cursor in the next row and enter data, it goes to the next row. Am I missing something?

You might find the following helpful. Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (wh...

Suggest you attach a sample file showing this issue so that we can evaluate it. Cannot manipulate data in a picture.

crossposting: and Please read this:-->

A Sample worksheet with mocked up solution would be very helpful here. The worksheet should probably not have more than 20 records. No pictures as w...

Move your pivot table to a fresh worksheet. Apparently you have more than one PT on the same sheet and they are overlapping. If this is not the case ...

Thanks for the feedback

Here is an alternative Power Query Solution

It would be very helpful if you attached a sample file which is reflective of your actual file (no confidential material included). We can then work ...

See if this works for you let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Filtered Rows" = Table.SelectRows(Source, each ([Pair...

If I understand correctly then, Power Query will do the work let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Ta...