Forum

To search into another table, create a combined key in that table: UserName * Title Then load the keys into a variable, KeysList = List.Buffer(Y...

Hi Sherry, If you create a null column in PQ and use a formula in that column, at next refresh it will be replaced indeed. But if you don't add this c...

Hi Nick, You cannot see the Quarter because it's not there, you have to create a Quarter column if you need it. Use this formula to add a new ca...

Hi Jack, Hard to see what you did without a sample file, can you please upload one? thank you

Try this in K2: =$K$1*(1+3%)^(ROW(A1)) K1 is the initial value

Hi Andy, To update the value with an inflation rate, try this formula: E2*(1+5%)^(F2-YEAR(NOW())) E2 is your initial value, F2 is the year selec...

Provide the error description you get and a test file that replicates the error please.

Yes, you can move AC:AD cells processing outside the "If Not tbl Is Nothing Then...End If" condition. "'If Not tbl.DataBodyRange Is Nothing Then' i...

Have you tried to sort and it does not work?

Hi Chris, Have to see the response of one request, not all API are built with the same structure. Some provide a total count and items per page l...

Try this code: (file also attached): Option Explicit Sub ClearData() Dim Wks As Worksheet, tbl As ListObject, ColumnsToClear As String, Cell...

A StartingValue of 0 is a bad idea, leading zero's are removed when converting to a number, will not work. Have you tried to type a number that sta...

You Can try VBScript, or: Or: Or, write batch scripts:

Rates should have a direct relationship with Membership table, (Rates should be a dimension table), not filtered through other dimensions. I create...

I think that the only way is to sign in as a different user, every time you use one of the files. You can do that from Global Permissions>QBO>...