**Andrea**,

"

*...I tried to just copy and paste the formula but I cannot get it to work, any advice?...*"

**Yes!**
Possibly when you copy the formula from my example worksheet and paste it into your actual worksheet, the copy is bearing the address of the original worksheet:

**[16_Fev_2017_Worksheet-OK.xls]**
This should be the cause of the error.

IF, the other worksheets

really have the same layout as the one you sent me to solve, then the

**CODES** tab formula, cell

**B2** is this:

= IFERROR(INDEX('SECTION 2'!$F$44:$Q$57, MATCH(B$1, 'SECTION 2'!$B$44:$B$57, 0), MATCH($A2, 'SECTION 2'!$F$43:$Q$43, 0)), 0) + IFERROR(INDEX('SECTION 2'!$F$65:$Q$77, MATCH(B$1, 'SECTION 2'!$B$65:$B$77, 0), MATCH($A2, 'SECTION 2'!$F$64:$Q$64, 0)), 0) + IFERROR(INDEX('SECTION 2'!$F$86:$Q$98, MATCH(B$1, 'SECTION 2'!$B$86:$B$98, 0), MATCH($A2, 'SECTION 2'!$F$85:$Q$85, 0)), 0) + IFERROR(INDEX('SECTION 2'!$F$107:$Q$119, MATCH(B$1, 'SECTION 2'!$B$107:$B$119, 0), MATCH($A2, 'SECTION 2'!$F$106:$Q$106, 0)), 0) + IFERROR(INDEX('SECTION 2'!$F$128:$Q$140, MATCH(B$1, 'SECTION 2'!$B$128:$B$140, 0), MATCH($A2, 'SECTION 2'!$F$127:$Q$127, 0)), 0)

**This is the only original formula. **
All others will be derived from this.

**Try to do:**
Simply

**Copy** the above formula;

**Paste **in ABA

**CODES** cell

**B2**;

**Select** Cell

**B2** and

**Copy**;

**Select** cells

**B2:H33**;

**Special Paste** -->

**Formulas**.

The magic is done.

Please tell us if it worked for you.

I really hope I have helped you.

--

Belo Horizonte,

**Brasil**.

Marcílio Lobão

My only problem now is trying to transfer this formula to another workbook - I have 3 of these sheets every week, in the same format that I am trying to get this to work in.

I tried to just copy and paste the formula but I cannot get it to work, any advice?

Thank you again! Great work!

Andrea