Forum

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? ...

Mohamed, This is the 3rd time I have asked you to attach a workbook. Without your actual file/query/data I can not help. Phil

Aye, Please always supply a workbook with data You haven't said how you are sorting but I'm guessing it's by the AccomCode. When I type those c...