I am trying to build a table that lets me compare expenses over a period of 6 months in a small area. What I want to do, is input transaction descriptions in A, expenses in B, income in C, and have a row of 5 cells that list expenses by type using LOOKUP. Gas, food, etc under these headings. The problem lies in how I want to implement the second tableset. I want there to be a month by month breakdown under each heading, that shows a month and what the expenses for that subset were: for 6 months. I want the table each month to automatically delete the first listed month and move the whole table up one row, to begin a new month as month 6.
I have not seen any single command that would allow me to do this, and don't see how multiple commands could allow this. I just don't want to have to delete a row, move it up, and generate a new one.