Hi

I have a dataset whereby I need to look through it to find a pre-defined search value. Once found, I have code to copy the entire row and paste it onto another sheet. For this, I am fine.

What I would like to do is add a functionality that will record on the other sheet, the row addresses from where they originated.

For example:
Dataset
Row Value
1 100
2 100
3 101
4 101
5 101
6 102
7 102

Search value = 101

I want to know they are found in rows 3 to 5

I was trying to modify this code (see below) but without success....

http://siddharthrout.wordpress.com/2...-in-excel-vba/

Any suggestions?