Forum

Hi Arunachal, at the start of the Validation() sub you're setting calculation to manual mode Application.Calculation = xlCalculationManual When...

Hi Arunachal, Please attach your workbook. Regards Phil

Hi Tim, Thanks for posting your solution. Regards Phil

Hi Abdelrahman, The VBA modules are password protected so I can't see them. Whats the password? I've watched your video, I'm not totally clear ...

Hi Rebecca, Can you please supply your workbook, or at least some sample data in the same structure. I need to run the code and the form against d...

no worries 🙂

Please, always supply some dummy data so we don't have to create our own. But, this will work let Source = Excel.CurrentWorkbook(){[Name="Table1...

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