Combining data from multiple sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been using OmniPage 12 to scan columnar data and then export it to
Excel.

So far I have had reasonable success with the OCR formatting but when
exporting the data, each scanned sheet becomes a sheet in Excel. I want all
the data on one sheet so that I can manipulate it (sort, pivot, etc.).

I have had no luck with help at the OmniPage bulletin board so I thougt,
alternatively, is there a way to combine data from multiple sheets that would
be simpler than copy/paste.
 
Hi Ron -

Have you tried going from the other direction?

If OmniPage allows you to save the files as Text (I believe it does), use
Excel's Data>Get External Data>Import Text File command (actual wording may
vary with version of Excel) and put the incoming data wherever you want.

HTH |:>)
 

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

how do i combine data from multiple sheets into one sheet? 3
Pivot from all sheets 1
Combine Data 1
Need a macro to combine the data from sheets 3
Combining multiple workbooks 1
combine data from multiple sheets 2
How to combine data from 100 similar Excel files 2
Pivot table data source 1

Back
Top