Forum Discussion
Importing data into a simple general ledger
Hello, I think that this will be a fairly simple question. I want an efficient way to import simple accounting data from staff cash reconciliation worksheets into an even more simple genera...
Hi Mike Gregory ,
That is job for Power Query - you may query your source file and filter all intermediate blank rows and rows with Data and Sub totals. Moreover, if you have in your Sharepoint folder few such files generated by different people you may combine all of them into one using From Folder connector. The only point all files have to have the same structure.