How to split excel worksheet into multiple excel workbook

0
votes

I have a workbook with 2 worksheet

one sheet looks like the following, i like to separate the workbook by pur group as highlighted worksheet

2nd sheets also with pur group, but different format as
2nd sheet

I like to have each Pur Group to have a separate work with 2 sheets (one called PO line item level, 2nd sheet called PO GRIR).

I am wondering if there is a quick way to achieve my goal. Any help is greatly appreciated.

excelvbasplitworksheet
What code have you tried so far? Where did you run into trouble with it? Please include that in your question. – braX