Previous Topic Next Topic

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

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses