Moving column and putting data into the new column

[godlyatheist]

I'm trying to automate adding new column to the a worksheet every week when I open the workbook. What I want to do is:

1) compared the value of two cells
2) if value 1 > value 2, then add column and do some formatting

Please Login or Register  to view this content.

I get an error 1004.

[godlyatheist]

Bump, can anyone tell me what I did wrong?