I received assistance with scripting a rest button for a complex sales tracker about 2 years ago and the original solution was extremely helpful. (

This is what it SHOULD look like when the script is done:

However, this is what the script is currently doing:

**Thank you for taking the time to review my dilemma. I appreciate you having a look!
**
(Side question: Google just updated its data validation drop down menus to have a constant background color when there is data (seen on the example sheet in range K30:K41). I hate this feature. Is there any way to make the data validation box transparent to allow the alternating colors to show??)

CodePudding user response：

On the range I4:K26, column K is item #2 in the array, as arrays start from 0.

Instead of

 if(vA[i][3]==1)

Write

 if(vA[i][2]==1)