I have an Excel spreadsheet and which consists of 3 dates, 1/1/03,
1/2/03 and 1/3/03. I can turn these dates into week numbers but need a
procedure which finds these week numbers in another sheet or another
section of the sheet and populates the empty cell below with the
amount of times it occurs. For example, 1/1/03 is week 1 so week 1 on
the other sheet is found and the number 1 is entered underneath.
Visual Basic is all new to me and would really appreciate some help.
I also need a way in which I can extend my chart ranges by 1 row
automatically on a regular basis.
Many Thanks.
Kieron White

---

Clarification of Question by kiza-ga on 17 Feb 2003 08:12 PST

I have an Excel spreadsheet and which consists of 3 dates, 1/1/03, 
1/2/03 and 1/3/03. I can turn these dates into week numbers but need a
procedure which finds these week numbers in another sheet or another 
section of the sheet and populates the empty cell below with the 
amount of times it occurs. For example, 1/1/03 is week 1 so week 1 on
the other sheet is found and the number 1 is entered underneath
because it occurs once.

Visual Basic is all new to me and would really appreciate some help. 

I also need a way in which I can extend my chart ranges by 1 row
automatically on a regular basis.

Many Thanks. 
Kieron White