# Thread: repeat formula from diferent SHEET's

1. ## repeat formula from diferent SHEET's

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?

2. ## EXCEL example

Here is the document I am working on.

Thank you.

3. Originally Posted by gcp
Is this possible, and can you help me?
Pleas see attachment, if you can help this formula and a list of all the sheets.

=INDIRECT("'" & ListSheets!A2 & "'!E6")

4. ## almost WORKING

Originally Posted by navic
Pleas see attachment, if you can help this formula and a list of all the sheets.

=INDIRECT("'" & ListSheets!A2 & "'!E6")

Dear NAVIC,

your formula works but very few cells are giving a mistake I do not understand why?

Can you check my file again?

(I had to reduze the original for me to be able to upload it)

Kind regards.

5. The errors are in rows 09 / 10 / 12.

6. Originally Posted by gcp
your formula works but very few cells are giving a mistake I do not understand why?
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

7. ## Perfect

THANK YOU VERY MUCH!

Sorry for the "stupid" last question...

Originally Posted by navic
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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•