I would like to be able to link the Customer info and invoice total to a
single report. There may be up to 200 invoices that need to be linked to a
single report. Any suggestions?

I gather that you have a file with some 200 invoices in it, presumably one
invoice per sheet. Is that correct? Or do you have some 200 files with one
invoice per file?
Either way you want to extract some info from each invoice and put it on
some sheet of some file in some format. Is that correct?
That would take VBA (automation). Post back if this is what you want
and include more detail about what you have and what you want to have. HTH
Otto
"guido10" wrote in message
...
I would like to be able to link the Customer info and invoice total to a
single report. There may be up to 200 invoices that need to be linked to
a
single report. Any suggestions?

Yes I have 200 invoices in 1 file. I would like to be able to take the names
and invoice totals and make them into a report.

"Otto Moehrbach" wrote:

I gather that you have a file with some 200 invoices in it, presumably one
invoice per sheet. Is that correct? Or do you have some 200 files with one
invoice per file?
Either way you want to extract some info from each invoice and put it on
some sheet of some file in some format. Is that correct?
That would take VBA (automation). Post back if this is what you want
and include more detail about what you have and what you want to have. HTH
Otto
"guido10" wrote in message
...
I would like to be able to link the Customer info and invoice total to a
single report. There may be up to 200 invoices that need to be linked to
a
single report. Any suggestions?