Last seen: Jul 3, 2025
Why vba? It's much easier for you in Power Query, all you need to do is to enter your credentials and select the table you need to bring into excel. ...
the 20210112-daily.xls file I included, as part of my testing had a first row cell with 1100+ chars so that one was always picked up the other 200+ fi...
CDO is not outlook, thought I just mentioned that. Are you sure you have a CDO signature? To help you answer this question, there is no signature i...
It's not that difficult, I gave you the formula, was hoping you can adapt it to your scenario. Returns the oie list because I used Text.ToList("Com...
If you use the debit ref, you can have as many credits as needed for 1 debit, as long as all credits have the debit ref. In the previous file sent,...
Try this one: let Custom2 = List.Select(Text.ToList("Combine"),each List.Contains({"A","E", "I", "O", "U","a","e","i","o","u"},_)) in Custom2
Not seeing anything usable unfortunately, sorry.
What's the difference? Still needs to combine 1 to many credits to identify a debit. The only notable difference is that now your Data Ref colum...
Not possible. That's CDO (not gmail) and it's a library, not an email client like outlook.
Hi Peter, You can have a separate table with as many columns you need, and write the headers in a single operation: ActiveSheet.ListObjects("Table2...
Is the above sample exactly how the source data looks like? Looks more like the desired output, rather than source data.
However, that formula works for same debit-credit amounts. Without a unique identifier that ties the credit transactions to that specific debit tra...
Have you tried this formula?
Hi Lea, How do you want to merge them into 1 file? In a single table or in 2 separate sheets? JE-after.xlsx does not have Employee code, so you don...
Hi Howard, The values that will sum to 0 will always be consecutive? For example, code should start from row 2 and stop when moving sum plus next row ...