Last seen: Jul 3, 2025
Hi Chris, Append Table2 to Table 1, this will create a single table with all data. Use this single full table to merge it with the single column ta...
I suggest recording a macro while removing duplicates manually, you will be able to reuse it and call it from the code provided, after the loop.
Just sending the file without saying what the problem is, is not at all useful. It's like saying "Houston, we have a problem..." The code works, re...
H Marsil, You can try this basic code (you need to add references to Microsoft HTML Object Library and Microsoft Internet Controls): Sub GetLi...
Hi Chris, Attached is an example, you can use that, or start with a blank query with this formula: = Excel.Workbook(File.Contents("C:UsersCatali...
Hi Chris, Not sure what you want. D Drive I guess is a local drive? You can use File.Contents(FilePath) , this will return file data in binar...
Hi Jacek, Try this: try let Source = Excel.Workbook(File.Contents("C:UsersCatalinDesktopNew folderSourceTable.xlsx"), null, tru...
Hi Mudita, It's not just a formula you need, you have to organize the data efficiently. For this, you have to ask yourself a few questions: A...
Hi Paul, in Excel, 1 day=1 unit, half day =0.5 units. 1 hour=1/24=0.041666667 =32.89/24 will give you 1.3704 days. If you format the cell...
Always use full references, unless you need it to work on active sheet by design (for an add-in). To be more accurate, the reference is still not c...
You are using relative reference to cells, and that is wrong. Cells(8,2) refers to active sheet. What if Sheet1 is selected? The following line ...
Hi Chiew, Normally, you should find the answer in a book, it's hard to condensate an answer that can take a few pages in a short message. You ca...
Hi Olusoji, Without seeing the file, it is impossible to say why. We have to see how the query is built, what measures are you using and so on.
Hi Jim, How did you get the Transform File(5) column?
Hi Trond, Can you run this code? MsgBox Cells(2, 8).Address You are using the range A2:B8 in the first test, but Cells(2,8) is not B8. Rememb...