combine data from multiple sheets

R

Roxypup

Hi,
I have imported data into excel using omnipro from a pdf file and it has
imported each page onto a seperate sheet (230 sheets), is there a way that
the sheets can be combined onto one sheet without manually copying and
pasting each sheet indvidually.

Thanks
 
C

CaptainQuattro

You need a simple macro to quickly perfrom this task.

It would take me a bit of trial and error to write the code, but I'm
sure some of the experts on this site have similar code already
written.

Try posting in the Excel programming section.


Good luck
 
Top