Forum

Hi, This can be done in a Power Pivot Pivot Table. Have you got PP? What version of Excel do you have? See attached for solution, and this post...

Nearly forgot to mention that you will need to make a change to the PQ Options otherwise every time the query runs PQ will ask you to give permission ...

Hi Brian, I can't write a SQL UPDATE without knowing things like your table and column names so here's some code that works on the AdventureWorks s...

You're welcome

You're welcome.

Hi Bruno, You can access the file in PQ using a From Web query and the URL to the file PQ will see it as an XLSX file and show you the 4 table...

Hi, This line Set ExpenseTable = ThisWorkbook.Worksheets("ExpenseData").ListObjects("Expenses") had curly quotes like this “” around Ex...

Hi Sue, wrap it in IFERROR e.g. =IFERROR(EDATE(C34,35),"") Regards Phil

Hi, Are you asking how to find out the chart type for all charts on the active sheet? Change the For Each loop to this For Each ChtObj In ...

Hi Please attach your workbook with the code that is generating the error. Phil

Hi Brian, You need to construct the SQL statement and then run it, without seeing you data I can't say anything more precise. You need a connect...

Hi Ivan, No file attached. Instructions on attaching files regards Phil

Hi Robb, You can add extra clauses to an if like so: = Table.AddColumn(#"Inserted Week of Month", "Custom", each if [Dates] >= #date(2020, 2,...

Hi Ronak, See attached file that uses a very fast function to calculate grouped running totals. On the 'In Stock GRT Function' sheet are the res...

are you unable to supply a copy of your live data? Without it, the help I can offer is limited. Are you using a custom list to sort in Excel? ...