VBA User Form with Excel datasheet

I have always prided myself on my general excel skills however I have given up with Pivot Tables and am less than a newb on VBA, sadly. I feel this little project would work much better with a user input and search form reading and writing to a seperate, possibly hidden sheet.

The sheet is simple to explain. The first few columns give date, customer account reference and name. The column headers are the products.

This file is a record of who ordered a product and when, which product and how many. We use this to track 'back-orders'.

Uses:

• Tells us how many to order

• Helps us keep track of incomplete sales orders

• Can be used to show how long we have been out of stock by subtracting todays date from order date

The user needs to be able to search for a customer account number, perhaps a dropdown list OR a product in much the same way, or a date.

• Drop down of product will list all customers and outstanding quantities

• Drop down of customer will show all products on back order for that customer ina nice report/list

• A date selection will show all customers, products and qty for the chosen date

If that's not asking enough, I'd like to be able to add a product and clear customer orders when we complete them.

I was reading this tutorial for ideas but to be honest with you I just can't get my head around it.

The attachement has two worksheets, one with the data, one I wanted to build the UI on but came to a grinding halt. Any help would be wonderful!

Thanks in advance.

I suspect that you could achieve a lot of what you want by putting auto-filters on row 2.