Help me2

  • Thread starter Thread starter TIMOTHY
  • Start date Start date
T

TIMOTHY

I've a database of one lakh products, 500 brands. I want to filter
some brands (artengo, btwin, caperlan, domyos, flx, inesis, kipsta,
kalenji, newfeel, nabaji, oxelo, quechua, simond, tribord)using vba.
Column name is manufacturer and suppose i dont know the column number.
 
Learn from the macro recorder - perform the steps manually, filtering on any column (field if you like) and see what gets recorded in the VBE. A little cleanup of the code and replacing the hard-coded column reference with a variable will sort you out. Sounds like you need to learn some Excel VBA. If so, I always recommend the following 2 sites:

http://www.excel-vba-easy.com - cheap and cheerful
http://www.vbafasttrack.com - more professional but costs more

Shouldn't take you very long at all to learn the basics to do what you want to.
 
Back
Top