Here is the document I am working on.
Thank you.
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?
Here is the document I am working on.
Thank you.
The errors are in rows 09 / 10 / 12.
You do not laugh at the name of the worksheet to have a blank sign (space) in front of the name worksheet
You have to pay attention to the names are spelled correctly worksheets
btw: It also performs, delete extra rows and columns that would have reduced the size of the file
Bookmarks