ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   merge multi worksheets to one (https://www.excelbanter.com/excel-discussion-misc-queries/191524-merge-multi-worksheets-one.html)

drury1998

merge multi worksheets to one
 
I have a file with 700 worksheets. I needed to combine them to a single one.
The headings are all the same. When I converted the table from PDF it made
each page a seperate worksheet.

Ron de Bruin

merge multi worksheets to one
 
Hi drury1998

See this code examples
http://www.rondebruin.nl/copy2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"drury1998" wrote in message ...
I have a file with 700 worksheets. I needed to combine them to a single one.
The headings are all the same. When I converted the table from PDF it made
each page a seperate worksheet.



All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com