Rag Tag Army
New Member
- Joined
- Nov 20, 2016
- Messages
- 5
Hi helpful geniuses.
I want to sum the same cell on every sheet following the sheet with the formula on it, but I can't guarantee the name or order of the sheets which follow it.
I can't simply sum from all sheets as the preceding sheet currently has data in some of the cells I want to do this with, and whilst a rebuild may be on the cards its not something I can undertake just now.
The best I am capable of achieving is bookending with blank sheets to give known names on either end, but this seems somewhat inelegant, and doesn't help with navigation or auto-indexing.
Whats the best way to go about this?
The first sheet contains a list of all the other sheets in the workbook in column A which is recompiled every time the sheet is visited if this is of any use.
Thanks in advance for any help.
I want to sum the same cell on every sheet following the sheet with the formula on it, but I can't guarantee the name or order of the sheets which follow it.
I can't simply sum from all sheets as the preceding sheet currently has data in some of the cells I want to do this with, and whilst a rebuild may be on the cards its not something I can undertake just now.
The best I am capable of achieving is bookending with blank sheets to give known names on either end, but this seems somewhat inelegant, and doesn't help with navigation or auto-indexing.
Whats the best way to go about this?
The first sheet contains a list of all the other sheets in the workbook in column A which is recompiled every time the sheet is visited if this is of any use.
Thanks in advance for any help.