Objective: to update cells (yellow) after selecting a product in the dropdown.
Situation: Currently, the file in attachment requires that I refresh the sheet with F9 in order to see the changes. Surely, there must be a way not to use F9...
Method 1: (one step) update yellow cells immediately after selecting a product in the dropdown.
Method 2: (two steps) update yellow cells not before clicking on the Display Data button after selecting a product in the dropdown.
Why asking for 2 methods? I need to know the differences in between the two methods (listed above) so I can learn from example.
My preferences go to Method 1 as it requires only one action from the user.
However, I would also want to know how to achieve objective with Method 2.
Thanks for your time and input.