Think you need to clarify what you're trying to do and what you're trying to do it with.

Posting a (de-sensitized) sample workbook with a 'before' and 'after' example would have us all dealing with the same thing.