Macro to cut data from multiple worksheets

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
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