Help with excel VBA, I'm trying to search a list and find all the matches based on the contents of a cell and copy and paste all matches RRS feed

  • Question

  • I am using excel 2010 and I and have made a template of a price sheet. The user selects a customer in a drop down list and I have macros set up to match the customer name to the customer code and display it on the price sheet. I need to search for matches in a large pricing list based on this customer code that is in the cell of the price sheet and copy and paste it into a different worksheet so my formulas can populate the price sheet. The price sheet has three columns : customer code, product code, and price. I am not very familiar with the workings of VBA and I could really use some help. Thanks in advance for any input.
    Bryan Vanderweide

    Bryan Vanderweide
    Tuesday, July 26, 2011 8:08 PM

All replies