Offset function, adding column and save-as

[Lithium78]

I need a macro that does the following:

1. add a column before the averages column

2. copies the previous data column. (so in this example it will copy column C) and paste that into the newly created column.

3. Then copy and paste only values to overwrite the values in column C.

Last I need it to automatically save as example 05-03-10.xls (but use the current date each day)

I'm very new with VBA and so far I'm just making a mess of things... is what I'm trying to do even possible?

Thanks in advance!