Selecting range in a column based on another cell value

Hello all,

I have a spreadsheet that has values that go up by intervals of 10 that extends from 500 to 1500; however each value occurs more than once (so the value 500 might occur 150 times, and 510 might occur 285 times etc). This data is in Column A. In cell B1, I have a value (e.g. 886). I want to be able to select the points before and after that interval. So it select all cells that are contain 880 and 890 and copies them to cell C1. Also if the cell in B1 changes, the range that is selected also changes to select the appropriate range of cells.

Any help would be greatly appreciated!

Thanks!

Edit: Sorry for the error, but I've cross posted this to "https://www.mrexcel.com/forum/excel-questions/1062781-selecting-range-column-between-two-values.html#post5103684"