Forum Discussion
lookup and add over multiple dynamic sheets excel
Hello,
i have a spreadsheet i am further developing. i am trying to look up and add qty's together to return a total qty required number for the same item over multiple sheets. the challenge is the sheet name and the number of sheets is dynamic to the project. so, the "j01 cabinet A" sheet will change name e.g. "j02 bench", "j03 kitchen B" etc... however the parts list within the sheet will remain constant. the qty's required for the different sheets will change based on the cabinet requirement. And i am wanting to have a qty summary sheet so i can procure off rather than go the individual sheets and manually tally.
any help much appreciated. thank you in advance.
thank you
One possible solution:
Insert an empty sheet named First before the first sheet that you want to include, and an empty sheet named Last after the last sheet that you want to include. When you need to create additional sheets, insert them between First and Last.
You can then use a formula such as =SUM(First:Last!K2) or =SUM(First:Last!M2:M100)
- as simple as this is - it worked. thanks Hans
