Abhishek A
Member
Hi
I want below formatting points in a single macro.. Could you please help me on this..
I want below formatting points in a single macro.. Could you please help me on this..
- Select all Rows starting at row 2 to the bottom
- Delete all rows that do not have “20” in column D
- Delete Columns H-AD
- Copy & Paste the following headers starting with the first date field (new column H)
DoB | DoH | Entry Date | Term Date | Disable Date | Death Date | Officer Staus Cd | Own% | YTD OverrideHrs | SrceLev Elig OptCd | Div | Term | Rehire |
- Delete the following columns:
- OfficerStausCd
- Own%
- YTDOverrideHrs
- SrceLevEligOptCd
- Div
- Save changes