Macro to cut data from multiple worksheets

Closed
clivemalungah
Posts
2
Registration date
Friday June 27, 2014
Status
Member
Last seen
June 30, 2014
- Jun 30, 2014 at 06:00 AM
Hi guys need help with a macro
Scenario
Have 3 WorkSheets (TEB,CEB,LTE) in a workbook called Cases
All worksheets contain same Column Names
I want ant a macro than will cut the rows from all these Worksheets based on Column G if it only contains the text "Completed"
This will be pasted into a new worksheet "Results"
It will be excellent if there is a button to do this and also to keep the fomatting