How do I get data from invoice template

G

Guest

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

template creates invoice - how to create summary worksheet? 13
Workbook Fotmula 2
Cumulatively list data from each new worksheet 1
How do i edit cells in an excel invoice template? 1
How do I move data from Excel worksheet to invoice? 1
Create an Invoice from a row of data 2
How do I feed info from invoice I created to a Spreadsheet 3
Invoice numbering 1

Top