Hi,
I have been trying to solve a problem but with no success.
I am designing a summary sheet which needs to pick up values from different sheets, all in the same document.
The formula I am typing is this: ='ON 1302'!E6 ( ON 1302 = sheet name)
I would like for the cell below to pick the same information (= same cell E6) but from the following sheet (ON 1303), which would be: ='ON 1303'!E6
Doing this is easy, the problem is to repeat this "ratiocination" to all the cell´s below, since I must pick information from more than 80 different projects/sheets ( ON 1301 to ON 1384) and in 11 different parameters - expenses, profits, taxes, etc....
Is this possible, and can you help me?
I have been trying to solve a problem but with no success.
I am designing a summary sheet which needs to pick up values from different sheets, all in the same document.
The formula I am typing is this: ='ON 1302'!E6 ( ON 1302 = sheet name)
I would like for the cell below to pick the same information (= same cell E6) but from the following sheet (ON 1303), which would be: ='ON 1303'!E6
Doing this is easy, the problem is to repeat this "ratiocination" to all the cell´s below, since I must pick information from more than 80 different projects/sheets ( ON 1301 to ON 1384) and in 11 different parameters - expenses, profits, taxes, etc....
Is this possible, and can you help me?