AckeemK
asked on
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
Report.xlsx
ASKER
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?
Which rows to be moved?
ASKER
All rows with a Status that says closed. I noticed I uploaded the incorrect file. Attached is the correct file.
Report.xlsx
Report.xlsx
I do not see any closed row here either.
ASKER
In column E, there header is named Status. Any row which has the status of "Closed", move to the "Closed" tab.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Don't know the layout for Mac 2011. In Office 2010 the Advanced Filter facility is under the Data tab.
ASKER
How would I modify this macro to move both rows that ready "Closed" and "Solved" to the 'Closed' tab?
Thanks
Rob H