(I will try not to bore anyone good\kind enough to spend their time reading
this, so I'll
cut out unneccessary details)

I'm a computer science student with plenty of experience with various
languages.
Unfortunately, I am not experienced with excel macros and excel tools and I
need to solve
a problem for a tracking spreadsheet for my part time job. It is as follows
(and any help would be MUCH appreciated) :

There are 3 worksheets in the workbook.
We'll call them Sheet 1, Sheet 2, Sheet 3 for simplicity.

It is for tracking sales on various dates for various categories of sales.
Let's just say a sale is of Type1, Type2, Type3 ... (up to say, 5).
These are tracked in columns with "check marks" (a number representing the
sales maker number)

The sale date (MM/DD/YY) is tracked in another column next to the Type
columns.
All of this is on Sheet1.

So it all looks like this:

Type 1 | Type 2 | Type 3 | Type 4 | Date (MM/DD/YY |
2 | | | | 08/01/03
|
| | 4 | | 08/02/03
|
| 1 | | | 08/03/03
|
3 | | | | 08/04/03
|
etc....

With all this in mind this is where the problem arises.
On sheet 3 I need to break down the sales into weekly sales (so between 2
given dates)
(which are dates in cells on Sheet1 because a week isn't always 7 days
unfortunately)
based on the type of sale.
EG (using the above example)
Week 1 had 2 Type1 sales in total.

I can do this on a line by line basis already by AND-ing the date with
whether it's of a certain Type, but it's for 30 to 400 sales per week, so it
needs to be some sort of loop (probably).

I know it's going to take some sort of macro or VB code, but I've never done
this before. (I am however a fast learner so don't avoid replying figuring
it will be wasted or confuse me, I just don't know how to approach it)