Macro to select assay after in every specific ragne

[genetist]

Hi,
I have data like this for exacmple
ASSAY MP Cm chr# Qty poly#
XY1723 408068 0.3 1 27 0
XY1727 463360 0.3 1 28 0
XY1708 880744 25.7 1 14 1
XY1709 900596 25.8 1 11 1
XY487 1174585 0 1 290 1
XY1641 1239146 27.3 1 5 0
XY1714 3057570 34.2 1 28 0
XY1721 3522443 34.2 1 13 1

This is biology data, my aim is to select ASSAY on every CHR# like this i have 12 chromosomes, The criteria to select assay is i want to select Assay based on MP column and CM column and i want to select ASSAY after a range of every100,000 (hundred thousand) value in MP column and every 5 Cm in CM coulmn. For example if i select XY1723 and i want to select another having MP column value equal to 508068 and CM column value difference must be 5.
Can any one help me with macro, i am good at using some excel formulas but not with VBA macro. I heared that macro will simplify my assay selection. I am attaching sample file that will help to understand more better than my explanation here. any help would be appreciated
Thanks
Regards,
Genetist