Move columns by selecting the day of the week

[Phil]

Hi,

I'm creating a spreadsheet that will store a few basic stats on a daily basis.

It would work as follows:
The user selects the current work day from a dropdown box.
By selecting the day, the column number is set. (So Selecting "Monday" would
set the column to B, "Tuesday" to C, etc.

The User would then press a button that would increment the value on a
preset row and the column assigned to the day of the week.

Thanks in advance

-Phil

 

[JLGWhiz]

What kind of drop down are you referring to?