Macro to fill down

Hi-

Currently I am using my macro to import my data and it feeds into the tab called 'Eze Comp P&L'. I have linked up formulas in tab 'P&l Estimates April '14'. Instead of having to go into the 'P&l Estimates April '14' tab daily after pulling in my data and doing a control D in columns B-G to to fill in the most recent day, what can I do? Is there some code i can right in macro tDaily Performance Report 4.22.14.xlsmo do this for me? Also in column F/G row 25, is there a way for code to also move that to most recent day?

Thank you

any thoughts?

Thanks

if you need me to give any more info, please let me know

Does this help?

Please Login or Register  to view this content.

Hi...Thank you. The b-g copy/paste special work. The below does not work. In F25 the cell populates with f=432, and g=432. Any ideas?

Please Login or Register  to view this content.

Worked when I tested it on your sample.