combine data from multiple sheets
 

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

combine data from multiple sheets
 

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


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=530807

combine data from multiple sheets
 

Hi Roxypup

You can try
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Roxypup" wrote in message ...
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