ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   summary data sheet from worksheet to worksheet (https://www.excelbanter.com/excel-worksheet-functions/89739-summary-data-sheet-worksheet-worksheet.html)

KKay

summary data sheet from worksheet to worksheet
 
I have several sheets that includes information on several parts that were
measured and I would like to create a summary sheet that aranges the data
from the part sheets and into the summary sheet while putting them into a
column, there I can do some analysis on them. I can hand type each cell to
look at a specific cell within the sheets but when there are over 100 sheets
it can be a very long process.

What would be the best way to arrange this data?

Ron de Bruin

summary data sheet from worksheet to worksheet
 
Look here for a possible solution
http://www.rondebruin.nl/summary.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"KKay" wrote in message ...
I have several sheets that includes information on several parts that were
measured and I would like to create a summary sheet that aranges the data
from the part sheets and into the summary sheet while putting them into a
column, there I can do some analysis on them. I can hand type each cell to
look at a specific cell within the sheets but when there are over 100 sheets
it can be a very long process.

What would be the best way to arrange this data?





All times are GMT +1. The time now is 09:24 PM.

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