I have data which is broken up into days. I need this to be segregated into weeks. Is there an easy way to use VB or a macro to do this?
Here is a sample of what I am doing (I want to insert a column that says "week 1" after the first week, "week2" after the second, and so on). The weeks are designated sat-fri.
Tuesday Wednesday Thursday Saturday Monday Friday
100 100 100 100 100 100
So, I'd like it to say:
Tuesday Wednesday Thursday Week1 Saturday Monday Friday Week2
100 100 100 300 100 100 100 300
I have no idea how to do this without manually looking at all 730 columns. Any help would be greatly appreciated!!
Here is a sample of what I am doing (I want to insert a column that says "week 1" after the first week, "week2" after the second, and so on). The weeks are designated sat-fri.
Tuesday Wednesday Thursday Saturday Monday Friday
100 100 100 100 100 100
So, I'd like it to say:
Tuesday Wednesday Thursday Week1 Saturday Monday Friday Week2
100 100 100 300 100 100 100 300
I have no idea how to do this without manually looking at all 730 columns. Any help would be greatly appreciated!!