How to easily combine excel sheets into one

I am doing some process automation and need to find a way to easily take an excel sheet that combines all sheets into one easily.

We have an MFP that scans sheets and OCR's to PDF but it takes each page and puts it as a separate sheet (usually 3 or 4 pages), I would like to just get all sheets on one long file.  The step after this is to copy/paste this info to another excel document.  Looking to do this with just one click, or shortcut key.  This is with office 2010
LVL 1
rhwimmersAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Paul SauvéConnect With a Mentor RetiredCommented:
OK - I tried this out with my MFP software, to no avail!

I think the only thing to do is to use the automatic document feeder... it will keep scanning until it runs out of pages to scan!
0
 
Paul SauvéRetiredCommented:
Most scanners allow you to scan multiple pages into one file.

This being said, since you are using OCR, I would suggest you create a RTF or a MS Word file rather than a PDF file..

This can be easily copied in one fell swoop into an Excel file.
0
 
rhwimmersAuthor Commented:
It needs to end in excel for math and sumif's...
0
 
Paul SauvéRetiredCommented:
>>We have an MFP that scans sheets and OCR's to PDF...

What I meant was to scan to a RTF/DOC/DOCX document rather than to a PDF document...

It is easier to copy to Excel than PDF...
0
 
rhwimmersAuthor Commented:
What I meant to say was it OCRs FROM pdf - to Excel!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.