ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Combine Worksheets (https://www.excelbanter.com/excel-worksheet-functions/134058-combine-worksheets.html)

William@Target

Combine Worksheets
 
I have 13 worksheets, same workbook and same column titles. Looking to
combine all 13 worksheets into 1 master worksheet. Anyone know how?

Wood Grafing

Combine Worksheets
 
If you aren't going to be doing the same thing repeatedly, then why spend
time writing code to do it?

Delete the title rows in the ones to be copied, select all, paste at the
bottom of the receiving sheet. Rinse and repeat as needed.

"William@Target" wrote:

I have 13 worksheets, same workbook and same column titles. Looking to
combine all 13 worksheets into 1 master worksheet. Anyone know how?


Ron de Bruin

Combine Worksheets
 
See this page
http://www.rondebruin.nl/copy2.htm

--

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


"William@Target" wrote in message
...
I have 13 worksheets, same workbook and same column titles. Looking to
combine all 13 worksheets into 1 master worksheet. Anyone know how?




All times are GMT +1. The time now is 11:03 AM.

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