View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
phil phil is offline
external usenet poster
 
Posts: 201
Default Move columns by selecting the day of the week

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