Moving completed items from one table to another (on another sheet)

doctorevii2001

New Member
Joined
Nov 19, 2015
Messages
21
I have a fairly simple workbook that I track my tasks. What I am trying to do is connect a macro to a button that will take all items that are completed in one table to another table on a second page. Here is the construction of the workbook and tables:

Sheet: Task List

ABCDEF
1DoneItemDate AddedDue DateDate CompletedType
2Follow up on formula12/6/1612/8/16Task
3xAsk Question12/6/1612/7/1612/7/16Task
4

<tbody>
</tbody>

Sheet: Done

(table is identical to that on Task List)

More Details:
I have a macro button set up to insert a new line at the top of my table (for adding tasks and not having them go to the bottom)
I have formulas set up so when I enter something in the Item column the Date Added autopopulates. Similarly when I put an "x" in the Done column it autopopulates Date Completed.

Goal:
When I click to insert a new line in my "Task List" sheet I would like it to cut all rows that have an x in column Done (A) and paste it in my table on sheet "Done."

If it helps, the current (super basic) VBA I have on the Insert New button is:

Code:
Sub Button4_Click()
Sub AddARow()
    Rows("2:2").Insert Shift:=xlDown
End Sub

I have gotten bits and pieces of what I'm going for to work, but when I try to pull it all together it fails royally and I can't seem to isolate the problem. I appreciate any help you might be able to offer!

(I'm moderately new to VBA, so I get the basics, but feel free to talk "dumb" to me, I appreciate the learning and guidance!)
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,191,691
Messages
5,988,120
Members
440,126
Latest member
duque00

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top