combine data from multiple sheets

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
how do i combine data from multiple sheets into one sheet? 3
Combine 3 of 6 worksheets 1
Combine Data 1
How do I combine multiple Excel sheets? 1
Copy all Rows from Several Sheets to 1 Sheet At Once 1
Summary from multiple sheets 1
another combine lists question 3

Top