software

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


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: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=530807Hi Roxypup

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

--
Regards Ron de Bruin
www.rondebruin.nlquot;Roxypupquot; gt; wrote in message ...
gt; Hi,
gt; I have imported data into excel using omnipro from a pdf file and it has
gt; imported each page onto a seperate sheet (230 sheets), is there a way that
gt; the sheets can be combined onto one sheet without manually copying and
gt; pasting each sheet indvidually.
gt;
gt; Thanks