So I have an Excel sheet that keeps track of my bill paying at work. I am constantly moving cells around and was wondering if Excel could move them for me. So here is what I have,
A 1 -6 list out my bank accounts and B 1-6 list out the amounts in each account.
A8 has my main account balance (I manually update daily)
A9 has bills waiting to clear the bank (B32 total)
A10 has my true main account balance (A8-A9)
Here are the bills waiting to clear the bank (Pending) that the amount goes into A9
A13 Name of bill B13 Amount of bill C13 Has the due date
(This process goes all the way down to row 31)
So what I have is a template that has all of my monthly bills sorted out the same as A13 through C13 that are in A59, B59 and C59 all the way down to 83. So each month my sheet starts out with blank amounts and I fill those in as I get the bills. So basically I have all my bills listed and as they become due I move them into the waiting to clear the bank rows, then once they clear the bank I move them out and into a bills paid Column E58, F58 and G58. Everything always takes 3 columns (Name, Amount and Due Date).
Hopefully I haven't lost you, but I just wanted you to get a sense of my spreadsheet.
So what I would like is to stop manually moving the rows and add a 4th column and once I put an X in that column it moves that row to the bills waiting to clear row. Then once it is paid at the bank I put a P in the 4th column and it move that row to the bills paid column.
So basically I have 2 questions
I know how to move 1 column in a row (In Cell B13 =SUMIF(D59, "X" ,B59) but can you move the row (A,B and C)59 into (A,B and C)13?
Can excel pick the first empty row A,B and C 13 through 31 to put the data?
I hope this some what makes sense and Thank you in advance for any help you can provide!