find last input row.. copy down block of formulae to this row.

See attached workbook: you will see the columns in yellow are where data will be inputted, all other columns contain formulae referenced to these yellow columns.

What will normally happen is that the input columns (yellow) will all have data copied down to the same row numbers (in this case all inputted data ends at row 7.) The problem
is that having all the formulae go down to row 25,000 makes the workbook a very large file.

I am looking for this improvement:

The formulae are only populating the first row.
Data is inputed in all the input columns.

Then this macro:
a bit of VBA that identifies the last row, and then drags the formulae down to this row.

Is there an easy way of doing so?

Best wishes!

M

Maybe:

Please Login or Register  to view this content.

Untested, try on a copy first.

What's it doing? How is it not working?

See edit above.

Originally Posted by JOHN H. DAVIS

What's it doing? How is it not working?

See edit above. I think the formula is too long to input.

Also, its taking too long.. Thousands of lines of data will be inputted at any time!

Yes your formula may be too long, but when you place the formula in code, you have to double your quotations within the formula:

Please Login or Register  to view this content.

Depending on how large your file is this may speed it up a little.

Originally Posted by JOHN H. DAVIS

Depending on how large your file is this may speed it up a little.

Nice work.

Sounds like you have it working. Glad to hear that, and thanks for the feedback.

Please acknowledge Forum Rule No. 9

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.