Forum

Before getting too far into this, are you sure that all words with an s at the end are plural? What about tennis, as in 'womens tennis shoes'? And...

Hi Azid, Please see the attached workbook which does what you want. I've created data validation lists for Cols D and G. I've created some cond...

Hi Cheryl, So using the exact query I provided results in no files found? If the path was correct that would indicate there are no files in the fol...

Hi Girish, Power Query does exactly what you describe and you don't need to do any coding. And it works for data that you add to the table at a la...

No worries, hope the recovery goes well.

Hi Girish, No need for VBA, use Power Query. The attached file does what you want. regards Phil P.S. I removed your email address. I yo...

The authorization process for the API is quite complicated and I haven't been able to get it to work in PQ in Excel. You can use Power BI Service t...

Hi Cheryl, You have to use the Sharepoint root directory to make the connection, which makes things a bit unwieldy unfortunately. You can get a ...

You're welcome.

Hi Salim, To modify the code for this type of general use - find these lines at the bottom of the function and comment them out: ' Select C...

Hi Erik, If you've already set up a custom list by going in to: File > Options > Advanced > General then right click on the slicer ...

Hi Steve, without your workbooks it's impossible to write a formula for you! Regards Phil

Hi Gold, Not being able to see the entire web page makes it difficult to give you code that will work, so I can only go with what you have provided...

Hi, I don't see how that code will work, URL isn't set to an actual URL? Without the full VBA and HTML code from the web page it makes it diffic...