Hi there Excel gurus heres my little question
I am trying to write a program that looks in ColA (starting at A2, A1 is a header) and deletes all rows that do not meet around 30 different texts.
I am trying to filter out all the stocks that are not on the DJIA (30 stocks)
I'm not that familiar with VB but I can reading up and can understand simple code, if anyone has done something similar and has code that would be great. You could leave the strings as A,B,C,D... instead of the 30 stocks tickers
The data is huge, I have 40 worksheets containing T columns and 27xxx rows. I'm trying to reduce the size of the file from 110mb to something more manageable