Forum

Hi Catherine, You didn't say what version of Excel you have. In modern versions of Excel, Power Query is built-in, not a separate add-in. You...

Hi David, In Excel 2019 Power Query is built-in, not a separate add-in. You'll find it on the Data tab, in the Get & Transform Data section....

Hi Christy, Can't help you without your workbook, please attach it. Phil

Hi Arunachal, at the start of the Validation() sub just remove the line Application.Calculation = xlCalculationManual Regards Phil

Hi Rebecca, The MATCH function requires an exact match when the last parameter is 0 and in my blog post I used it this way to look up values that I...

Hi Girish, I created a solution using Power Query so your data must be able to be combined using PQ? Regards Phil

Hi Abdelrahman,, Sorry without the password to examine the code I can't do anything to help. Regards Phil

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