gabriellepullum
New member
- Joined
- Aug 18, 2011
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Ok so here's my question. I'm trying to make a recurring pattern (or autoformat idk what u call it) for my budget spreadsheet I'm making on excel...
I want every 37th row to start a new chart.
basically this chart reflects my pay date (ALWAYS THE FIRST B CELL),
underneath that row, the subheadings reflect bills i have to pay/items to be purchased (A Cell), the total of those bills (C Cell), the price of each bill (B Cell), that weeks paycheck amount (D Cell), extra money i have been able to make or money given to me (H Cell), the total amount of extra money given (F Cell), the description of those extra's (I Cell), the total amount of unspent money i started out with (paycheck before bills are payed + any extra money, E CELL) and the amount of money I will have left after bills and other expenses (G Cell). These subheadings fill up columns A-I.
Formula's have already been entered in the following row. every pay date i've been maunually copying and pasting the chart from the previous pay week into a new row and then manually changing the pay date and deleting old data (data from previous's weeks paycheck and expenses). i want to prevent having to do this by somehow having every 37th row simply repeat the same chart, with the same formula's, with no data included (so i don't have to keep manually deleting old data) AND the corresponding pay DATE (every friday) which is always the very first B cell in the chart. i have manually entered dates 8/19/11 and 8/26/11 already. how do I continue the dates in the first B cells so that i don't have to keep changing it, and also just have this chart repeat itself every 37th row?
FYI - I want the chart to repeat every 37th row because that starts a new page (starting from row 75, when page is set to LANDSCAPE). This makes it easy for when i ever decide to print out my budget. i just basically start it at the 37th row so the subheadings appear on the top of each new page.
can you help? i've attached an example so maybe u can see what i mean.
THANK YOU!
I want every 37th row to start a new chart.
basically this chart reflects my pay date (ALWAYS THE FIRST B CELL),
underneath that row, the subheadings reflect bills i have to pay/items to be purchased (A Cell), the total of those bills (C Cell), the price of each bill (B Cell), that weeks paycheck amount (D Cell), extra money i have been able to make or money given to me (H Cell), the total amount of extra money given (F Cell), the description of those extra's (I Cell), the total amount of unspent money i started out with (paycheck before bills are payed + any extra money, E CELL) and the amount of money I will have left after bills and other expenses (G Cell). These subheadings fill up columns A-I.
Formula's have already been entered in the following row. every pay date i've been maunually copying and pasting the chart from the previous pay week into a new row and then manually changing the pay date and deleting old data (data from previous's weeks paycheck and expenses). i want to prevent having to do this by somehow having every 37th row simply repeat the same chart, with the same formula's, with no data included (so i don't have to keep manually deleting old data) AND the corresponding pay DATE (every friday) which is always the very first B cell in the chart. i have manually entered dates 8/19/11 and 8/26/11 already. how do I continue the dates in the first B cells so that i don't have to keep changing it, and also just have this chart repeat itself every 37th row?
FYI - I want the chart to repeat every 37th row because that starts a new page (starting from row 75, when page is set to LANDSCAPE). This makes it easy for when i ever decide to print out my budget. i just basically start it at the 37th row so the subheadings appear on the top of each new page.
can you help? i've attached an example so maybe u can see what i mean.
THANK YOU!