Hi,
I receive a standard output when I export some data from an accounting software package into Excel.
My aim is to transform this into a structured output so that I can pivot the data and create reports.
I've attached an Excel workbook. "Sheet1" is an example of the output from exporting from the accounting package, and the tab "Consolidated" takes the first two invoices as an example and I've consolidates them in my required format. I would want to do this for all the entries in 'Sheet1"
Things to note:
Every "Item Code" is followed by the "Item Description"
Every time the word "Customer ...." appears in column A we are referring to a new invoice. The invoice number is also in Column A (Total Invoice...") but right at the end of the list of Item Codes" and "Item Descriptions"
The relevant date for the invoice in in column B on the same row as the invoice number (Total Invoice...")
I've managed to find snippets of code to search for certain word's such as "Customer" etc. but I'm battling to make it dynamic in the sense that the number of items per invoice changes depending on the invoice.
Would really appreciate some help.
Thanks a million!
Bookmarks