VBA to copy a formula from a cell range and paste it to a cell range based on date

Hi All,

I hope you can help me come up with a VBA code wherein it copies a formula from a cell range and paste it to a cell range based on current date that matches in column A where dates are located. The copy function should be similar to a default copy past in excel were it adopts when you drag down a certain formula. Thanks.

Please see my file attached.

Thank you in advance.

Maybe :

Please Login or Register  to view this content.

Try:

HTML Code: 

Originally Posted by karedog

Maybe :

Please Login or Register  to view this content.

Yes! This is exactly what I mean and wanted to happen. But what I really need in my final excel is instead of paste referencing it to today, I would like to past it on the previous week instead. It should still look for the current date as the previous week will be based on the current day.

Please see attached file sample

Originally Posted by tax112

Try:

HTML Code: 

this paste the formula to the future dates also. Not really what I meant. Sorry if I wasn't clear.

Should be :

Please Login or Register  to view this content.

You are welcome, thanks for marking the thread as solved and rep.points.

Regards