The software for cemetery that I use wasn't made by an accountant. It spits out data in the most horrible format possible. I've attached an example of how the data is outputted and also how I would like it to be. Somehow I need to search for each account number (they are formatted 0000-00) and then put the corresponding information with it. The example book will show you what I mean. The number of lines for each invoice is different so there's no simply formula that I can come up with that will work.
Is this possible to do or is it far too complicated?
Also note that the actual data is about 4500 lines long.
Thanks
Bookmarks