Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 7, 2026
Topics: 61 / Replies: 1588
Reply
RE: IF FORMULA WITH DATES IN EXCEL LINKED TABLE

Hi Amien, No file(s) attached. You need to click on the Start Upload button. Without seeing your data I can't be certain but you my benefit for...

6 years ago
Reply
RE: #Ref error when refresh data

Hi Walid, What is it you are actually trying to do? Why are you copying data to a new sheet or workbook? Can you please supply your workbook(s)...

6 years ago
Forum
Reply
RE: When cell value changes (daily stock prices) , copy the information to a new worksheet To make a dynamic chart (date & value)

Hi Walid, I wrote a post on this Plot real time data in Excel and recently answered a question on the same topic How to plot live data in ...

6 years ago
Forum
Reply
RE: Choose which Outlook account to send email

Hi Marsil, Insert this snippet into your code after you've created objOutlookMsg Dim Account As Outlook.Account For Each Account In objOutloo...

6 years ago
Forum
Reply
RE: PQ FORMAT & DATE FORMAT ALL THE SAME DATES

Hi Dave, No files are attached. You need to click on the Start Upload button after selecting the files. Regards Phil

6 years ago
Forum
Reply
6 years ago
Forum
Reply
RE: need to copy historical data from this link

Hi Faha, PQ won't be able to get that data because the data is generated by JavaScript and isn't stored in a <table> element on the page. ...

6 years ago
Reply
RE: Column is Not Updating?

Hi Leslie, In that sample file, the header name had a trailing space so it was actually 'DOW ' not just DOW. Remove that trailing space and it wor...

6 years ago
Forum
Reply
RE: Multiple csv-files and changing content

Hi Maarten, Did you mean to attach files? You need to click the Start Upload button after selecting the files. Phil

6 years ago
Forum
Reply
RE: HELP | POWERSHELL TO VBA

Hi, Can you give an explanation of what it is trying to do and what you want. It looks like it is trying to get some info about Groups on Yammer...

6 years ago
Forum
Reply
RE: VBA for monthly data in table

Hi Faeza, No file attached. Regards Phil

6 years ago
Forum
Reply
RE: Column is Not Updating?

Hi Leslie, Please attach your query too. Phil

6 years ago
Forum
Reply
RE: I am stuck trying to figure out how to parse information

Hi Steven, As I noted in the PBI forum, the date issue is due to them being in US format and you need to change them using Change Type -> Using ...

6 years ago
Forum
Reply
RE: How to plot live data in Excel

Hi, You can't tell Excel to only check for changes every x seconds. If you are using worksheet change events like this, they will trigger when the...

6 years ago
Forum
Page 36 / 110
0