Forum

Hi, When the Validation sub runs you have these 3 lines of code at the top LR = Range("U" & Rows.Count).End(xlUp).Row LR1 = Range("B" ...

Hi Philip, Use a free OneDrive account to store the file then share with us. Phil

Hi Hima, You can use a free OneDrive account to store the file then share the link to it Regards Phil

Philip Treacy said Please supply a workbook with data and clear explanations of what you want and the expected result. Thanks Phil I can't he...

Hi, If data is filtered, for example in a table, VLOOKUP still returns the same data. Filtering has no effect. Maybe if you explain what you ar...

Hi Umesh, I'm not really sure why you are using filters and then copying data between sheets? If I was searching for something I'd write a sub lik...

Hi Umesh, That Google Drive link is asking me to request access for the file. Can't you just attach the file to this thread? Video instructions...

Hi, List.Intersect requires the lists be supplied as a list. As written above it thinks that List2 is the 2nd optional parameter equationCriteria ...

Hi, This query will insert a blank row after every 3rd row: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Ta...

Hi, You need to double up on the double quotes inside the string, otherwise it looks to VBA like you are ending the string because there's a single...

Hi, Why do more work than you need to? If Power Query can do this then that's what I'd use. If PQ can't do it then we can look at a VBA solution. ...

You're welcome. Next time you supply the HTML just copy the entire page rather than a part of it so that errors like missing tags don't happen. ...

Hi Sholtan, As I said in the other thread, I believe your are cross posting these questions. The people who try to help you give up their own ti...

Hi Sholtan, I believe your are cross posting these questions. Please read the terms for using this forum as you are in breach If you contin...

Hi Rajsha, The HTML excerpt you provided only had 1 UL in it, but that's ok to get this working. However there are other bits of code that are m...