Macro for multiple tasks
I have a series of steps i need to code for a macro and dont even know how
to start! Can anyone help please?
1- To the right hand side of column G (i.e. column H) take the date from
column G which is in dd/mm/yyy y format and change to ddd format €“ putting
this into column H (this should be applied to the whole column, at the
moment the column is 400 lines long but this can grow so its best not to
specify).
2- Once the above is done, the whole sheet should be sorted by column H
(this is the ddd format cells)
3- The days of the week should be counted in some way and then the day that
appears most should be highlighted (if i could get a table of results
somewhere then that would be brilliant!)
4- Msg box to appear telling user which day of the week is most popular..
Appreciate your help.
Thanks.
|