Macro help applying formula to dynamic number of rows for different files (s/b EASY)

Thanks that works! When I record the macro (not in VBA code) is there a way to get this to work correctly? Thanks again!

You can't record a dynamic range. You'd have to modify after you record.