Macro to create a sheet and copy rows into that newsheet

Closed
clivemalungah
Posts
2
Registration date
Friday June 27, 2014
Status
Member
Last seen
June 30, 2014
- Jun 27, 2014 at 08:05 AM
Hi everyone,

I have a work book with 3 work sheets.
Each work sheet contains 12 similar columns
How do I write a macro to create a new sheet (summary) with all values from the 3 worksheets based on a value Yes in column K
So if Column K has value Yes, I want it copied to a new sheet (summary)for all worksheets.
If possible can it remove that data from the 3 worksheets