paulanthony
New Member
- Joined
- Aug 19, 2005
- Messages
- 9
I want to be able to change sheet wide a formula for a SUM sheet wide at present the formula looks like this..
=SUM(Toome:Dublin!C6)
This is for a summary sheet.
My problem is that C6 occasionally needs to change to say C7. This is replicated in many cells, so I decide to store the value "6" in a cell so that it can change easily across the sheet. As a programmer in other languages I use something like Eval to do this, however im a bit stuck as to how this would work in Excel..
=SUM(Toome:Dublin!C Eval(=CELL(BLAH)(VALUE)) ) kinda gives a feel for what im trying to achieve.
=SUM(Toome:Dublin!C6)
This is for a summary sheet.
My problem is that C6 occasionally needs to change to say C7. This is replicated in many cells, so I decide to store the value "6" in a cell so that it can change easily across the sheet. As a programmer in other languages I use something like Eval to do this, however im a bit stuck as to how this would work in Excel..
=SUM(Toome:Dublin!C Eval(=CELL(BLAH)(VALUE)) ) kinda gives a feel for what im trying to achieve.