Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Aug 22, 2025
Topics: 61 / Replies: 1579
Reply
RE: Connecting to PayPal in Power BI

Hi Falk, Are you trying to access the Sandbox or live data? If you are trying the Sandbox, I believe it only contains data that you put there b...

3 years ago
Reply
RE: Change Conditional Formatting Rules based on User Input (vbyes/vbno) Response

Hi Amanda, If you put columns for Brand and Size in the ItemRunData table, you can then sort/highlight the table based on those columns. regards...

3 years ago
Forum
Reply
RE: Power Query dates

Hi Carl, Please attach your file when asking a qs - without your file I can't see what you are doing or what may have gone wrong. If you look at...

3 years ago
Forum
Topic
Replies: 1
Views: 309
Reply
RE: VBA to update vendor information

Hi Jose, Please supply the workbook that you want this to work with. It's very difficult to provide you an answer without that workbook's data and...

3 years ago
Forum
Reply
RE: True and False on number relationship

Hi John, No need to post the same question in different forums, just once is enough. The logic in your question is difficult to understand. Why...

3 years ago
Reply
RE: Power Query to unstack data when it doesn't recur regularly

Hi Cullen, Yes the #"Added Custom3" step does as you describe. Not sure how the Project, Activity and Description columns ended up blank in my f...

4 years ago
Forum
Reply
RE: Excel work calender with automated invoice generator

Hi Mohammed, Please supply your Excel workbook(s) and examples of the layouts/results you want. Regards Phil

4 years ago
Reply
RE: Problem Scraping Paginated Table- Resets Order After Each Page

Hi Mike, That website isn't giving the results correctly. It shouldn't be duplicating results like that. Not much we can do to prevent this as al...

4 years ago
Forum
Reply
RE: For Each Loop to Send Multiple E-mails

Hi Amanda, Please supply a sample workbook with your question, it can be very difficult to debug code without the data it's working on. In this ...

4 years ago
Forum
Reply
RE: Changing chart and types using VBA - and eliminate the requirement for macros.

Hi Andy, Macros are another term for the code written using VBA. So macros = VBA. If macros/VBA were the only way to do what you want, then I'm...

4 years ago
Forum
Reply
RE: COUNTA counting "blank" cells

Hi Cullen, The result of your IFERROR when there is an error is "" , which is an empty string, and that isn't the same as a blank cell. If you u...

4 years ago
Topic
Replies: 4
Views: 260
Reply
RE: Power Query to unstack data when it doesn't recur regularly

Hi Cullen, Seems that Mynda and I were both working on this and didn't know the other was doing so! At least you get 2 different solutions to your...

4 years ago
Forum
Reply
RE: Power Query Replace Data

Hi Julia, As long as your new dataset has the same structure as the old one then yes. When I say structure I mean the dataset must have the same...

4 years ago
Forum
Page 19 / 110