| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i enter data in multiple sheets simultaneously | Excel Worksheet Functions | |||
| Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
| Lookup data from multiple sheets | Excel Worksheet Functions | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| sumif to add data in multiple sheets | Excel Worksheet Functions | |||
Hybrid Mode
