In added example file where what you want is done without any coding.
I left your original sheets as they were. You can delete them.
Sheets with names starting with "H_" are meant to be hidden.
On other sheets, columns with dark brown headers are meant to be hidden.
On hidden sheets, you must have in Tables enough rows to have full info for any client you have registered. Currently both tables allow maximally 20 entries. To add rows, select any cell in bottom row and drag it down.
Instead of cascading validation lists to select products and varieties, I advice to combine them and have a single validation list - as I did in my example.
|