Dear all
Kindly advise how to set Excel Macro and filter data to new worksheets.
I have worksheet DATA as attached.
I will like to set macro so that:
a) new worksheet contain data for ORG begins with DDD
b) new worksheet contain data for ORG not begins with DDD
Note: ORG in column J highlighted in yellow and letters in blue
I have tried to do so but encoutered error and ended up with no filtered data in the newly created worksheet
Kindly advise
Bookmarks