Filling Down Formulas

I have nine columns (Columns A to I) filled with formulas. Generally, every time I would enter something in the next blank row available in Columns J and onwards, the formulas would automatically fill down to that row. However, if I want to put information in multiple rows at once (for example, copying and pasting eight rows of information from another workbook into this sheet)...the formulas in columns A to I only fill down one row.

Please Login or Register  to view this content.

I only want the formula to fill down if there happens to be data in Columns J onwards (so until a blank row). Is there any way to accomplish this?

Is the formula the same for all rows in each column? Do you only want to put the formula in the row in which Column J gets a value, whether you manually enter 1 or paste from another sheet?

Each Column from A and I has a different formula... And yes, essentially I want the formula to be in the rows in which Column J:Column L gets a value. Thanks for your help!