Macro to move rows to another sheet

I am looking to create a macro that checks a column called "Status" and moves rows from the "Current" sheet to the sheet called "Closed".
Report.xlsx
AckeemKAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
Try this

Sub moveclosed()
Range("A1").CurrentRegion.AutoFilter 5, "Closed"
Range("A2").CurrentRegion.Offset(1).Copy Sheets("Closed").Range("A" & Rows.Count).End(xlUp).Offset(1)
Range("A2").CurrentRegion.EntireRow.Delete
End Sub
0
 
Rob HensonFinance AnalystCommented:
Take a look at the Advanced Filter facility. This can filter data for specific criteria and copy to another location.

Thanks
Rob H
0
 
AckeemKAuthor Commented:
I never dived into that facility and I'm guessing to locate it on Mac is different from Windows. Is it possible you can described where and how I can make this action occur on Mac Excel 2011?
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Saqib Husain, SyedEngineerCommented:
Which rows to be moved?
0
 
AckeemKAuthor Commented:
All rows with a Status that says closed. I noticed I uploaded the incorrect file. Attached is the correct file.
Report.xlsx
0
 
Saqib Husain, SyedEngineerCommented:
I do not see any closed row here either.
0
 
AckeemKAuthor Commented:
In column E, there header is named Status. Any row which has the status of "Closed", move to the "Closed" tab.
0
 
Rob HensonFinance AnalystCommented:
Don't know the layout for Mac 2011. In Office 2010 the Advanced Filter facility is under the Data tab.
0
 
AckeemKAuthor Commented:
How would I modify this macro to move both rows that ready "Closed" and "Solved" to the 'Closed' tab?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.