Moving columns automatically when the date changes, business days only

[victor505]

Hi, thank you for your help. I would like to move columns to the right as the date changes. For example, the top of the column has the current date. Within the column are about 40 rows of data. as the date changes, I would like that column to automatically move to the right and show that column with yesterday’s date, and have that data associated along with it moved. I am looking for 6 months of columns to store, with the current date in the first column and subsequently moving right with the previous dates and info.
------------------------------------------------------------------------------------------------
August 7, 2012 | August 6, 2012 | August 5, 2012 | August 4, 2012 | August 3, 2012
------------------------------------------------------------------------------------------------
Accepted Processed Accepted
Rejected Accepted
Processed Processed
...
and so on

any help is appreciated, thanks!

 

[John Davis]

Will the date change only on the first Column or Range("A1") ?

 

[victor505]

No, the date changes in every column, along with it changing the data in that column will need to stay with the date it was entered. so as each new day comes, all the columns move down to the right one. hope this helps, thx for asking!