Help to create automatic moving of data from Sheet 1 to Sheet 2

[ashleika]

Hello,

I am trying to setup a document and my visual basic skills have not been used in about 10 years.

Sheet1 look something like this.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Description
[/TD]
[TD]Processed[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]11/23/2014[/TD]
[TD]Hats[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Carol[/TD]
[TD]10/24/2014[/TD]
[TD]Jacket[/TD]
[TD]No[/TD]
[/TR]
</tbody>[/TABLE]

I would like to take all items that once updated to say "Yes" in Processed Column will then remove the data i the row and move to Sheet2 which will then house all the processed records in one spot

Please help!

 

[Smitty]

Welcome to the Board!

Why not just use a Pivot Table? That way you keep the data aggregated in one spot, but can report on it any way you want.

 

[ashleika]

Welcome to the Board!

Why not just use a Pivot Table? That way you keep the data aggregated in one spot, but can report on it any way you want.

Thank you. Would that not result in me having to copy and insert an updated pivot table daily? Would like it automatic in the case someone other than myself is updating.

 

[Smitty]

Nope, you can tell Excel to refresh it automatically:

Refresh Excel Pivot Table Automatically