How to pull transactions into a template based on a customer code?

Hi,

Apologies, I originally posted this in the Excel General forum but i've been giving it a lot of thought on the way home and I feel that VBA is going to offer me the best solution (possibly through an autofilter and copy combination?).

MODs please could you delete my original post located here? http://www.excelforum.com/excel-gene...omer-code.html



My Query:

We've got a bug in our finance system where it can't handle any transactions that have sales but no related commission. The BI team provides a CSV file separately with this information and the sales team has to manually input it. I know how to create a template that can be uploaded into the system but don't know how to pull the data into the template from the CSV file.

I've created the attached example and what i'd like is a drop down box in cell B1 (template tab) listing all the customer codes in column B on the data tab and then based on your selection all the related transaction lines pull into columns A to F (starting on row 4).

I hope this makes sense? If not give me a shout!

Thanks in advance,

Snook