Forum

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

Hi Cristian, Without your workbook it's difficult to understand exactly what the issue is, or test what is happening. Please, always attach a work...

Hi Netty, Please don't click the Quote button, it just duplicates the previous post. Use the Add Reply button instead. Thx Phil

You're welcome

The code does enter a VLOOKUP only for visible cells in AA. If you are getting some other result please attach the workbook again so I can see what...