At least in your test folder, the amounts were not positinonized consistently. Otherwise, it was actually quite simple.
Now you have to test...
You don't need to do anything with the combobox. When you select a cell with a data validation list, the code will position the combobox over the cell...
JoePublic Today, 09:43 AMThese are the columns that I need at the end - all information is already contained in the file extracted.
...
It is probably not a big problem to split the vertically arranged vendor blocks into individual columns, but in the end there will be too many columns...
pinarello Yesterday, 11:38 PM
Extract data from 1 column in txt with Power Query
Here now with all needed columns. You just have to check if I interpreted the columns correctly....
pinarello Today, 12:09 PM