I'm doing a budgeting spreadsheet in excel. Along the top, the columns are headed for each budget item I need to account for. The rows are each labelled with dates on a daily basis. At the end of each week I have a row that balances the totals for each week.
My question is this, I want to be able to fill down the date column and any other columns that have identical or pattern data, but I'd like to skip the total balance row that I have at the end of each week, thus maintaining the date sequence.