I have created a macro that creates new sheets from a master sheet by calendar year. On each new sheet a totals row is copied from the master sheet and entered below the last row of data through the macro. The macro works correctly. I want formulas in the totals row that would sum the amount in each column starting at row 9 and ending one row above the totals row. This row will be differnt for each sheet. Is there a dynamic range formula I can use for this?