Quote:
Originally Posted by ArviLaanemets
I used Defined Tables feature.
I also used named ranges (nStartAge, nEndAge) - them you also can see and edit in
About Progress and Feedback - add columns for them into data Table, and enter them there! When you want to enter them on separate sheet, then the ID for them MUST be entered manually - otherwise you can't guarantee that this info remains linked with right ID.
And you don't need different reports for different age groups.
|
hm...
Ah, thank you for the explanation, I can work with that.
The data table is generated automatically by a software and includes many more ages, which aren't relevant to the guys working with the file (hence my question about the 2 helping columns).
That's why we need the filter in the first place.
I thought I'd be able to fetch the "ID"s from "data" with your method, generate a sheet with the additional info fetched directly from data via INDEX or VLOOKUP (since "ID" is unique) where the people can enter their progress and feedback.
Thank you, so so much!