Macro to fill down

[cartica]

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

[cartica]

any thoughts?

Thanks

[cartica]

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

[JOHN H. DAVIS]

Does this help?

Sub carticaaabbcczz()
Sheets("P&L Estimates April '14").Range("B3").End(xlDown)(1).Copy
Sheets("P&L Estimates April '14").Range("B3").End(xlDown)(2).PasteSpecial xlPasteFormulas
Sheets("P&L Estimates April '14").Range("C3").End(xlDown)(1).Copy
Sheets("P&L Estimates April '14").Range("C3").End(xlDown)(2).PasteSpecial xlPasteFormulas
Sheets("P&L Estimates April '14").Range("D3").End(xlDown)(1).Copy
Sheets("P&L Estimates April '14").Range("D3").End(xlDown)(2).PasteSpecial xlPasteFormulas
Sheets("P&L Estimates April '14").Range("E3").End(xlDown)(1).Copy
Sheets("P&L Estimates April '14").Range("E3").End(xlDown)(2).PasteSpecial xlPasteFormulas
Sheets("P&L Estimates April '14").Range("F3").End(xlDown)(1).Copy
Sheets("P&L Estimates April '14").Range("F3").End(xlDown)(2).PasteSpecial xlPasteFormulas
Sheets("P&L Estimates April '14").Range("G3").End(xlDown)(1).Copy
Sheets("P&L Estimates April '14").Range("G3").End(xlDown)(2).PasteSpecial xlPasteFormulas
Sheets("P&L Estimates April '14").Range("F25").Formula = "=F" & Range("F3").End(xlDown)(1).Row
Sheets("P&L Estimates April '14").Range("G25").Formula = "=G" & Range("G3").End(xlDown)(1).Row
End Sub

[cartica]

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?

Sheets("P&L Estimates April '14").Range("F25").Formula = "=F" & Range("F3").End(xlDown)(1).Row
Sheets("P&L Estimates April '14").Range("G25").Formula = "=G" & Range("G3").End(xlDown)(1).Row

[JOHN H. DAVIS]

Worked when I tested it on your sample.