Button to reset variable data list.

Ok I think this might be asking a bit much...

I have created a fairly simple table of variable data (list) drop downs.
As I change each entry from drop down lists, a total accumulates.

To reset the table, I manually change each drop down to a blank cell (blank cell that I added to the drop down list).
is there a way to instead have a 'button' that changes the whole row to the blank cell in the dropdown list?


does this make sense?

Are the dropdowns on a worksheet??

yes it is basically a table (6x5) of drop downs. there it a total at the far right of each row.

so when you want to reset the totals, you currently have to go back through each drop down (30 in total) manually.