update list with specific cell values in uncreate sheets (templates)

**dmendes** · 06-19-2013, 02:58 AM

hi!

I´m new at this forum and i pray that someone can help me with this one! :D

I have 1 "overview" sheet, where it is included a table with 3 columns ( date, score and status). each row (meaning each 3 values of date, score and status) will be the 3 values from a new Evaluation. each Evaluation is 1 new sheet in the workbook and all Evaluations have the same template and therefore these 3 values will always be placed in the same cells in all Evaluations (let´s say will always be placed on D3, E4 and F4 cells)

So, what do I do to "add" a row of these 3 values in my Overview sheet every time I open a new Evaluation sheet? i know how to link cells between sheets but in this case i´m referring to sheet yet to be created...so that doesn´t work...any idea?

all suggestions are welcome!

p.s. - I have no idea on macros or complicated functions so if that is the solution please try to explain it as if i was 5 years old :D thank you!

**Ace_XL** · 06-19-2013, 03:06 AM

Maintain consistency in naming of your evaluation sheets e.g. Evaluation1, Evaluation2, Evaluation3 etc.

Then for Evaluation 1 use in your Overview Sheet

=SUM(INDIRECT("Evaluation"&ROW(A1)&"!D4:F4"))

Copy down for other results

**dmendes** · 06-19-2013, 03:33 AM

hi! thank you!

i think i didn´t explain it properly...i dont want to "sum" =add anything. I want the Overview table to have another row with the new 3 values. Also in the formula you refer "Evaluation" but do you meant "Evaluation1"?

Ah! the "real" cells to copy from will be E1, D4 and E4

here goes the file

Once again thanks for the help!

**Ace_XL** · 06-19-2013, 03:39 AM

In your Overview sheet

In A56
=IFERROR(INDIRECT("'Evaluation "&ROW(A1)&"'!$E$1"),"")

In B56
=IFERROR(INDIRECT("'Evaluation "&ROW(A1)&"'!$D$4"),"")

In C56
=IFERROR(INDIRECT("'Evaluation "&ROW(A1)&"'!$E$4"),"")

Copy down
Rows 57 onwards will populate once you have the newer Evaluation Sheets created