G
Gareth
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
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