Hi,
I have some task to do.
There is a one list with some rows, and for each of them I need to add some values from the second list. The clue is that this task is going to be done by people who do not know excel at the high level so writing formulas, merging tables etc. in not the way.
Let’s look at my example:
I have two tables:
What do you think is the best way to do it?
I was thinking about creating the user form with all items from the list 2 together with checkbox’es each time the user click on ‘edit’ value in the first list, but I have never created forms before ☹
The interface does not need to be beauty, It should be user friendly only cause there are more than thousand rows to be completed.
Because this task – I think – can have the wide range of use, maybe there was any solutions ready to use with user forms or another sheet showing and hiding, or any different way to achieve that?
I attach also the screen of my source tables and the result I expect to achieve.
result:
I have some task to do.
There is a one list with some rows, and for each of them I need to add some values from the second list. The clue is that this task is going to be done by people who do not know excel at the high level so writing formulas, merging tables etc. in not the way.
Let’s look at my example:
I have two tables:
- the first one with names of shopping lists (date of shopping, name of the list and cell with ‘edit’ value),
- the second one contains the names of goods we can buy.
What do you think is the best way to do it?
I was thinking about creating the user form with all items from the list 2 together with checkbox’es each time the user click on ‘edit’ value in the first list, but I have never created forms before ☹
The interface does not need to be beauty, It should be user friendly only cause there are more than thousand rows to be completed.
Because this task – I think – can have the wide range of use, maybe there was any solutions ready to use with user forms or another sheet showing and hiding, or any different way to achieve that?
I attach also the screen of my source tables and the result I expect to achieve.
result: