Hi everyone,
We have multiple invoices in an excel format that has been setup like a document with an invoice header and then invoice line items and totals. We have hundreds of these that have to be imported to an existing access database. At the moment people are manually entering the details. Is there a way I could either get the relevant data from each invoice file and load into a new "import friendly" excel worksheet so I can easily import each file OR is there some vba code or macro I could use to collect the relevant data in an appropriate format? I have attached a spreadsheet showing how I would like to structure the invoice header and a sample of how the files come to us at the moment. The fields are always in the same specific cell locations on every invoice file.
Any help would be really appreciated!
We have multiple invoices in an excel format that has been setup like a document with an invoice header and then invoice line items and totals. We have hundreds of these that have to be imported to an existing access database. At the moment people are manually entering the details. Is there a way I could either get the relevant data from each invoice file and load into a new "import friendly" excel worksheet so I can easily import each file OR is there some vba code or macro I could use to collect the relevant data in an appropriate format? I have attached a spreadsheet showing how I would like to structure the invoice header and a sample of how the files come to us at the moment. The fields are always in the same specific cell locations on every invoice file.
Any help would be really appreciated!