I have a spreadsheet where we have collected data for the entire year.
Every other row needs to be cleared out. I need a way to be able to
clear the data from these cells automatically. Can anyone come up with
a macro for this.

This is what I have This is what I
want
1
1
2
3
3
4
5
5
6
7
7
8
9
9