Copy Formila into alternate columns depndent on day

All,

I did post a thread reagarding this yesterday - but the replies I recvd haven't quite worked to my expectations.

I have ammended the exisiting Macro to simplify my requirements. Please refer to attachment in the 1st instance. I'll try my best to explain what I'm after - basically a Macro to copy and paste one column and then fill cell contents in a 2nd column with a specific formula. However the cell positions will change on a daily basis.

For example on a Monday I need the following formula -=COUNTIF('Raw Data'!A:G,Main!B11) placed in cell D11 and looped down column D until cell D901. Then on Tuesday, all the data in D11:D901 needs to be copied and pasted so values remain and the formula needs to start in E11 and loop until E901 and so on until end of week.

Could you complete as a macro that I can run in a command button in the spreadsheet please.