How do I get data from invoice template into Excel proper. I have invoices of
my customers as single files. I am trying to extract data from each field in
the invoice template, such as first name, last name etc. Can someone suggest
a way of doing this?

If all the files are in a single folder, if all the the data is on a worksheet
with the same name, if all that data is in the same location (exact same
addresses), then a macro could consolidate all the data it finds.

sibik wrote:

How do I get data from invoice template into Excel proper. I have invoices of
my customers as single files. I am trying to extract data from each field in
the invoice template, such as first name, last name etc. Can someone suggest
a way of doing this?

--

Dave Peterson