Using a macro to autofill a formula in a worksheet. Problem is that data is different each week, meaning that there are a differing amount of rows each week. Of course, the macro I am creating uses an absolute number of rows, meaning I either have to fill the remaining, or delete the extra, eliminating the efficiency gain by creating the macro.

Please help!

BW