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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

logical function template 5
a way to append data from 2 different files 2
Assistance with VBA and drop down list 0
Hiding entire row(s) on entering data in cell(s) 2
NEWBIE: How to sum cells using VBA 1
Filtering 2
Help me4 2
Help with autofilter and filtering a specific column 1

Back
Top