Selecting alternate rows
I have a large file (Excel XP) with about 300+names and related details. I
need to break it into 2 files but I need to select alternate rows for each
file. It may come out to every 3rd row to work into 3 files.
Is there a quick way to do this rather than tediously select each alternate
row, copy to the new file and delete from the old file?
Many thanks for your help.
Norm.
|