Joris Hermans
New Member
Hello there to you all.
I've been strugling for some times with this issue ... and it seems I can not find the sollution myself .. That's way I post my question here.
Some feedback.
I need to build some kind of "to do list", but with tons of reporting linked to it.
The first chalange I encounterd, was to present the user a list of only active tasks and no blank lines.
As shown in my graph, I find a sollution (maybe not optimal, but fine for the moment) by first creating a temporary table, using vlookups and validation of the status. Next stap was creating a new table, dropping the empty lines.
So far, so good.
Now I'm presenting this dataset to the users in some modified views; only a limited set of records (5 lines) witch the user can scroll using a Form Controll scroller.
At the end of each line, (the first next collumn after the table/view), I put 5 checkboxes, so users can change the status of that record.
Altought the checkbox and its position on the sheet do not change, the cell it need to be linked at, will change depending on the line number (sequence), is on the acual row.
So, checkbox 1 - 5 should first be linked to the first 5 records of "Status" of the first table "Status"
But when the users looks at record 4 - 9, the same checkoxes should be linked to the values of records 4 - 9.
I made some kinda screenshot to clear things out.
ALL suggestions to handle this (even if it means I will have to rebuild the sheet from scratch), are welcom.
BUT ... I prefer to do so NOT using VBA. Will it be possible?
I've been strugling for some times with this issue ... and it seems I can not find the sollution myself .. That's way I post my question here.
Some feedback.
I need to build some kind of "to do list", but with tons of reporting linked to it.
The first chalange I encounterd, was to present the user a list of only active tasks and no blank lines.
As shown in my graph, I find a sollution (maybe not optimal, but fine for the moment) by first creating a temporary table, using vlookups and validation of the status. Next stap was creating a new table, dropping the empty lines.
So far, so good.
Now I'm presenting this dataset to the users in some modified views; only a limited set of records (5 lines) witch the user can scroll using a Form Controll scroller.
At the end of each line, (the first next collumn after the table/view), I put 5 checkboxes, so users can change the status of that record.
Altought the checkbox and its position on the sheet do not change, the cell it need to be linked at, will change depending on the line number (sequence), is on the acual row.
So, checkbox 1 - 5 should first be linked to the first 5 records of "Status" of the first table "Status"
But when the users looks at record 4 - 9, the same checkoxes should be linked to the values of records 4 - 9.
I made some kinda screenshot to clear things out.
ALL suggestions to handle this (even if it means I will have to rebuild the sheet from scratch), are welcom.
BUT ... I prefer to do so NOT using VBA. Will it be possible?
