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

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

Hi Roxypup

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

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


"Roxypup" <[email protected]> wrote in message news:[email protected]...
> 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