Novice98052
07-12-2010, 11:34 AM
Hi, I'm working with an excel spreadsheet where I have a large list of components with various prefixes eg: BR11 3D72 located in column A. I'm trying to find an easy way to take every component with the initial prefix "3D" and list them into another spreadsheet in the same document. I'm guessing there's no easy way to macro this? If this is the case, what would be the easiest way to accomplish this task. Is there an if() command I can use or does this involve advanced VBA programming? Thanks in advance