travis.m.roberts
Board Regular
- Joined
- Jul 7, 2009
- Messages
- 62
Is there a way to automatically have a formula updated to include any tabs that are added? I have a spreadsheet that starts out with two tabs (summary page and one heavily formatted sheet). The summary page has a bunch of formulas on it that I would like to have updated to include values from a new tab each time it is inserted. For instance if the formula is =SUM('090800'!Q35) and I add a tab named 090900 I need the formula on the summary page to be updated as such: =SUM('090800'!Q35,'090900'!Q35). Is that possible?