I have 2 columns of data, A2:A? contains week numbers in ascending order and
B2:B? contains orders received in that week.

I now have to put this date into a chart. This is no problem but there are
some week numbers missing, want I want is a little macro to add in the
missing numbers and enter a 0 in colun B . For example:

Column A Column B
Week No. Orders
1 23
2 29
5 23
6 56
8 55


This should look like:

Column A Column B
Week No. Orders
1 23
2 29
3 0
4 0
5 23
6 56
7 0
8 55

Thaks in advance.

Gareth