Forum

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

Hi Mardi, Please supply the workbook. Regards Phil

Hi Maggie, I was working on this update (attached) and as I go to post it I see your latest message. Please try using this new version to see if...

Hi Tim, What version of Excel are you using? If I divide an array by another array with a 0 in it, the only #DIV/0 I get is in the position corr...

Hi Mark, Please see attached. This code is taken from here VBA Progress Bar I've rewritten the code to be more adaptable, so that when initi...

Thanks Kurt 🙂 I'm using VS Code but only for the sake of taking the pretty pictures. I copy the VBA into it and take the screen shot. Unfortun...

Hi Ramzan, That is a big task, you should start with the scraping posts I linked to above. Then maybe check our Dashboards course for presenting...

Hi Declan, I've written some VBA that will do this for you Show Report Filter Pages for Power Pivot PivotTables Regards Phil

Hi Ramzan, Do you want to scrape the data from this site and present it in Excel, or do you want to write your own system where it takes a keyword ...

Hi Mark, Can you supply the workbook plz? Phil