I am looking for a macro to copy rows from a spreadsheet and create separate worksheets based on data in Column O keeping the original spreadsheet intact.
Data in Column O isn't sorted and changes almost daily so I can't hard code anything.
Ex.
<tbody>
</tbody><colgroup><col><col span="2"><col><col><col span="2"></colgroup>
In this example I would like the original sheet and two additional sheets, one "Closed" and one "George" with the associated rows copied to Sheets "Closed" and "George".
I have tried my best to do this but sadly all of my attempts have ended in failure.
Can someone with much more knowledge than I have give me a hand?
Thanks
Bob
Data in Column O isn't sorted and changes almost daily so I can't hard code anything.
Ex.
1 | A | B | H | I | N | 0 |
2 | Defect # | Severity | Detailed Description | Target Date for Resolution | Date Last Update | Awaiting Response From |
3 | 1 | 3 | Information Not Populating | 6/30/2017 | Closed | Closed |
4 | 2 | 4 | Information Not Populating | 7/1/2017 | 7/1 | George |
<tbody>
</tbody><colgroup><col><col span="2"><col><col><col span="2"></colgroup>
In this example I would like the original sheet and two additional sheets, one "Closed" and one "George" with the associated rows copied to Sheets "Closed" and "George".
I have tried my best to do this but sadly all of my attempts have ended in failure.
Can someone with much more knowledge than I have give me a hand?
Thanks
Bob