Creating a macro that does not copy amount of rows from file

Hello,

I am trying to create a macro that does NOT copy the amount of rows in the file the macro was recorded in.

For example:
The macro is specific to the amount of rows in the file when you're recording the macro. If there are 1700 rows in the file when you create the macro, it's carrying those formulas down for 1700 rows. However, if I download data for one day (as we often will), it still pastes the formulas for 1700 rows even though there's only ~20 actual rows in the new file.