Need help on a macro script that delete columns, rows , unmerge cell and filter column header
Details listed below for the order of macro.
- Active Sheet name is "Prompted Report" and
- Needs to delete rows 1-4
- Unmerge all mere cells
- Delete cols, h-k, AA-AX
- Filter column header
- delete code 1Am under col header division
Any help is much appreciated