Hi I need to create a Macro that will take a large data set and perform a series of Filters.. To Ultimately Select the remaining Data information. Below is the set of steps:
Filter
1.Column (GX)- ALL_Status, Filter Out 'Completed'
2.Column (DW)- Low Util PON, Low Filter Out 'Blanks'
3.Column (EX) - TLA, Filter out ALL future dates greater (>) than today.
Copy/Transpose
4.Capture in File the following columns with Data reflecting:
-Groomer Id (AD)
-Plan Tracking Code(E)
-Ckt Type (M)
-Internal CKt Id1 (R)
-Low Util Pon (DW) TLA (EX)
5.Lastly I would like to transpose that information into a seperate sheet or file if thats possible (OPTIMA_TLA)
6. Then Sort by Groomer ID - A-Z
Any Help Much Appreciated!!
Bookmarks