Help me fix my budget please!!!
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.
Last edited by gabriellepullum; 08-18-2011 at 04:51 PM.
Re: Help me fix my budget please!!!
I had to do something similar a few years ago. I modified your workbook just slightly. In this version you enter into the last row and get a new row for that date. To add a date click the button at the top. Page breaks are added to keep the data for each date on its own page and the title section is set to the first two rows on the page (do a print preview). See the attached example.
If this is helpful, pls click Star icon in lower left corner
Re: Help me fix my budget please!!!
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1