ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Generating parts list from multiple sheets (https://www.excelbanter.com/new-users-excel/138159-generating-parts-list-multiple-sheets.html)

Prescher

Generating parts list from multiple sheets
 
I am having trouble generating a parts list from multiple sheets in a
workbook. I am calculating sell price for entire projects. I have many
different furnaces that can be used and I would like to generate a list of
the furnace and other equipment that I use into a final sheet that I can then
use to order materials for the project.

Max

Generating parts list from multiple sheets
 
If your multiple source sheets are identically structured,
this sample from my archives might be of some relevance:
http://savefile.com/files/414328
Interactive Summary.xls
(nicely rendered, full details inside)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Prescher" wrote:
I am having trouble generating a parts list from multiple sheets in a
workbook. I am calculating sell price for entire projects. I have many
different furnaces that can be used and I would like to generate a list of
the furnace and other equipment that I use into a final sheet that I can then
use to order materials for the project.



All times are GMT +1. The time now is 06:25 AM.

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