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