I'm not clear on a couple points:

<I would like to have Macro #1 to do the following:

<1) copy all of the values in the range M6:BL155 and paste in the
range
<L6:BK155

You want to copy the range and move it one column to the left?

<2) clear the contents of the cells in range BL6:BL155

Then you want to clear the last column (BL) of the original data?

<3) adjust the header dates +7 days (L5=5/15/09, M5=5/22/09....BL5=5</
12/10)

Then you want to add 7 to each date in your header row?

I'm wondering what that would do for you. Was the original data
entered under the wrong dates?

Do you want to do the every day, week or month?

I'd like to see your description of what you are trying to accomplish,
rather that how you want to accomplish it.

There a lots of references in the archives about copying and moving
ranges.

Have you searched the newsgroups for an answer?

Hope this helps

Dan