I have a lost and found log that has 2 worksheets: (1) Unresolved and (2) Resolved. Data is entered into the Unresolved worksheet when something is lost or found. When a date is entered under Date Claimed / Sent to Capitol Police (column I), I would like the data in that row to be removed from the Unresolved worksheet and automatically inserted in the next blank row of the Resolved worksheet. I know very little VB, so any help is greatly appreciated. Thank you
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date Reported
[/TD]
[TD]Lost or Found?
[/TD]
[TD]Item Description
[/TD]
[TD]Name of Person Reporting Item
[/TD]
[TD]Phone No.
[/TD]
[TD]Keep item if not claimed?
[/TD]
[TD]Claimant Name
[/TD]
[TD]Claimant Phone No.
[/TD]
[TD]Date Claimed / Sent to Capitol Police
[/TD]
[/TR]
[TR]
[TD]6/1/14[/TD]
[TD]Found[/TD]
[TD]Pair of tennis shoes[/TD]
[TD]John Doe[/TD]
[TD]555-555-5555[/TD]
[TD]Yes[/TD]
[TD]Jane Doe[/TD]
[TD]111-111-1111[/TD]
[TD]6/25/14[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date Reported
[/TD]
[TD]Lost or Found?
[/TD]
[TD]Item Description
[/TD]
[TD]Name of Person Reporting Item
[/TD]
[TD]Phone No.
[/TD]
[TD]Keep item if not claimed?
[/TD]
[TD]Claimant Name
[/TD]
[TD]Claimant Phone No.
[/TD]
[TD]Date Claimed / Sent to Capitol Police
[/TD]
[/TR]
[TR]
[TD]6/1/14[/TD]
[TD]Found[/TD]
[TD]Pair of tennis shoes[/TD]
[TD]John Doe[/TD]
[TD]555-555-5555[/TD]
[TD]Yes[/TD]
[TD]Jane Doe[/TD]
[TD]111-111-1111[/TD]
[TD]6/25/14[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]