# Moving Rows - Not sure Excel can do this??? But...

1. ## Moving Rows - Not sure Excel can do this??? But...

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?

And

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!

2. ## Re: Moving Rows - Not sure Excel can do this??? But...

Look at the attached and see if that's kind of what you're working with and/or want.

Hope this helps.

-Z

3. ## Re: Moving Rows - Not sure Excel can do this??? But...

Thank you, that is pretty close. The only thing being that once it is marked with a "p" I need that amount to stop adding to my amount on B32. As 8,9 and 10 are to give me my true balance each day.

4. ## Re: Moving Rows - Not sure Excel can do this??? But...

OK, try the attached.

Hope this helps.

-Z

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1