Forum

Hi Chris, The topic title says 'when updating Power Query' - but the link is talking about connecting a query to the data model. So how exactly ...

Hi Corrie, no file attached. regards Phil

Hi Marsil. See attached file. From your image it looks like you want emails that are not in your default email account. In which case you need to ...

no worries Mark. You can copy/paste the loop into the ShowProgress sub to create an artificial delay - see attached. Though I'd be happy if my c...

Hi Alistair, What is your experience of VBA? Can you look through my code and see what it is doing? It boils down to: 1) Reading a row of da...

Hi Carlos, No file attached. There's a video here that shows you how to attach files Regards Phil

Hi Dan, Please read the forum rules Please start your own topic rather than adding to an old one. Please describe your problem in detail r...

Hi Alistair, See attached file. I've made the potential positive so the bars are above the x-axis. This requires Office 365 as it uses dynami...

Hi, What this section of code (in Reset) is doing is populating the list in the main section of the form. It's loading rows from the sheet. If...

Hi, In the Reset sub you have this line iRow = [Counta(SampleList!A:A)] ' identifying the last row but the sheet name is SampleReport so iRow...

Hi Cam, You didn't answer whether or not you have Office 365? Attached is a solution. Load Jim's properties in a query, load Susan's in another...

Hi Jim, Please supply the workbooks so we don't have to type everything in again. We can't write the query without the data 🙂 Thanks Phil

Hi Tim, So in that sample it looks like data from a pivot table copy/pasted + some extra columns? To check if a column has data you could use fo...

Hi Steve, Your code is looking for the first occurrence of the ID: Set findvalue = Sheet19.Range("Q:Q").Find(What:=ID, LookIn:=xlValues).Offset(...