Forum

Hi Bill, Google search results are location specific. The results it gives me when I search here in Australia will most likely be different to wha...

Hi Maria, No file is attached. You need to click the Start Upload button - instructions can be found here Regards Phil

Hi Howard, It's much easier to do this kind of thing directly in the command line. Writing VBA to call FSO is just using the Windows Shell/Command...

No problem Bill. Where do you want to get the company website address from? Looking at the results I get when searching, for 3M the 1st search ...

Hi, Please attach your workbook. Have you tried using the code in this blog post Plotting Real Time Data Regards Phil

Hi Daria, When I tried to open your file Excel told me that the VBA project and macros were corrupted. Can you please attach another copy of the...

Hi Bill, Please start your own topic if you have a question, don't tag on to someone else's topic. Your code doesn't work because you're looking...

No worries Robb.

You're welcome.

Hi Patrick, Your formula in Col I was referencing itself - you should have been given warnings by Excel about 'circular references' when you opened...

Hi Nawaf, PC specs are only part of the story. Performance in PP and PQ will be affected by things like: A poorly designed data model Writin...

Hi Chris, You could nest them inside each other but that'd be very ugly! Try this = Table.SplitColumn(#"Trimmed Text", "String", Splitter.Sp...

Hi Dave, If you're getting this data from the web then you should try using Power Query to get it. But with the data supplied already in Excel, th...

Hi Gokhan, No file is attached to your reply. Did you try my file? Regards Phil