Insert Rows w/Formulas

[Mikeandchanel]

I have a spread sheet with lookup formulas that lookup information in a diffrent worksheet. This is a delivery schedule and I have some rows that show the date and the other rows have the lookup formulas in certain cells. I insert new rows as needed for the deliveries (I never know how many there will be in a day) as they are scheduled. How can I make it so that the formulas with the lookup formulas are automatically placed in the cells that I want?

 

[Amnesiac]

Could you be more descriptive? Do you have a specific example for us to try? Would love to help but I need more information first to understand exactly what you are looking for. Thanks.

 

[Mikeandchanel]

I have a lookup formula in D2256 which is =Vlookup(C2256,'JobList'!$A$2,$C$400,3,False) I would like this formula to automatically appear in all rows that I insert. This would save me from having blank cells with lookup formulas in them when I dont need them.