selectively choosing data from column

D

darcyoil

I have a problem: I have a column with 45000 data points. But I want t
make a new data set by taking every 10-th value from the 45000 column
How do I do that? Please help
 
N

Nicky

Hi,
assuming there is a value in every cell in the first column, th
easiest way would be to copy the worksheet to a new sheet (to preserv
your original database) and select the first cell that you want t
preserve in the copied sheet (eg A1), then run this code which wil
delete nine rows, skip one, delete nine skip one etc until it hits
blank cell:

Sub del_rows()
Do While ActiveCell.Value <> ""
ActiveCell.Offset(1, 0).Range("A1:A9").EntireRow.Delete
ActiveCell.Offset(1, 0).Select
Loo
 
Top