ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   In Excel combine tables from multiple worksheets in to one sheet? (https://www.excelbanter.com/excel-worksheet-functions/32434-excel-combine-tables-multiple-worksheets-one-sheet.html)

Pau

In Excel combine tables from multiple worksheets in to one sheet?
 
I need to combine tables of data from several worksheets so that it is all
presented in one large table on a single excel worksheet. Is there a simple
function that can combine multiple sheets in the workbook?? Thanks for the
help.

Anne Troy

Perhaps you want to sum the same cell(s) in all workbooks?
http://www.officearticles.com/excel/...rk sheets.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Pau" wrote in message
...
I need to combine tables of data from several worksheets so that it is all
presented in one large table on a single excel worksheet. Is there a

simple
function that can combine multiple sheets in the workbook?? Thanks for

the
help.





All times are GMT +1. The time now is 01:21 AM.

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