How to easily combine excel sheets into one
Posted on 2013-11-06
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