Hi
I looking at some past data from last years Premiership. What I want to do is streamline the data that I have, so what I would like to do is delete the rows that don't match a criteria.
The criteria must be in either column B or C otherwise that row is deleted.
eg. the Criteria is "CHELSEA" so any rows that don't contain "CHELSEA" in columns B or C are deleted.
I know it would probably have to be a VBA code to do but I'm don't where to start.
Any help woulb be greatly appreciated!
Cheers
I looking at some past data from last years Premiership. What I want to do is streamline the data that I have, so what I would like to do is delete the rows that don't match a criteria.
The criteria must be in either column B or C otherwise that row is deleted.
eg. the Criteria is "CHELSEA" so any rows that don't contain "CHELSEA" in columns B or C are deleted.
I know it would probably have to be a VBA code to do but I'm don't where to start.
Any help woulb be greatly appreciated!
Cheers