Macro to bring down formula daily

[cartica]

HI-

In the tab titled P&L estimates, I have my macro button. It pulls in files into the eze comp P&L tab. Right now I have my formulas extended out everyday for the whole month in the P&L estimates tab. However doing this, will affect my numbers at the bottom. Is there code that I can add to my macro where it will just fill in columns C-H for the day I am running it that corresponds to the date in column A?

ThanksDaily Performance Report 4.15.14.xlsm

[cartica]

One more item. If I then Had Lines 25 for columns C-H = the most recent column, how can I also that that to macro, so that it will always = most recently filled.

[cartica]

any thoughts?

Thanks

[cartica]

any input? If you have any questions, please let me know. Thanks