PDA

View Full Version : Macro to find numbers in a single column



frogman
04-24-2016, 12:12 PM
Is there a way to search for a single column or any two columns of numbers and place them on a new sheet for review. I would like to be able to look for any-wheres from 2 to 20 of liked numbers. In this example am looking for four 3s so I place four 3s in AC5:AC8 and press the search button. I would also like to catch 15 rows above and below the numbers I am looking for. An example of what it finds is below

Here is a snip of what I am asking for.

16001

16002