I am trying to get my macro to work - and I can't seem to figure out what is wrong. The steps I want it to perform are to duplicate the GL Activity sheet; rename it as the CC integer; then delete the rows which are not the CC integer in the new GL tabs. I know the delete function is the problem - I just don't know what to do. Any help would be appreciated.

Dim i As Integer
Dim j As Integer
Dim Count_CC As Integer...