ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Merge Data From Multiple Worksheets (https://www.excelbanter.com/excel-worksheet-functions/8228-merge-data-multiple-worksheets.html)

Corby

Merge Data From Multiple Worksheets
 
I have I workbook with over 30 different worksheets. All of the sheets have
the same columns but different data. Is there a way to merge or combine all
of those worksheets into one without copying and pasting?

Thanks,

Corby


Frank Kabel

Hi
see:
http://www.rondebruin.nl/copy2.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Corby wrote:
I have I workbook with over 30 different worksheets. All of the
sheets have the same columns but different data. Is there a way to
merge or combine all of those worksheets into one without copying and
pasting?

Thanks,

Corby





All times are GMT +1. The time now is 05:14 AM.

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