I am handling a big data Excel page (lets call it page **P.Source**) and I need to use pointers to manage the strings in a very specific way.

I need to look all the ocurrences of a string in a column in the **whole rangue A:A** and for each ocurrence detection do the following:

```
"String detected in Ax cell" (x is the number of cell)
-> Set the pointer to A(x-3) cell and copy this value to other page (P.Other) into the cell A1.
-> Set the pointer to B(x-3) cell and copy this value to other page (P.Other) into the cell B1.

```

In triying to figure out this by using generic functions as .Find through a loop but Im having problems with it. 

I hope somebody can guide me with some function or operative method for approach a solution since I'm not very familiar with VBA. 

Thank you very much.

---

**EDIT:**

Completing the coment of 

> 
> Gary's Student
> 
> 
> 

What I want to to do is the following:

Taking this as P. Source:

![Image](https://i.imgur.com/cHGZqNv.jpg?1)

The result I want is the following in P. Other (taking "happiness" as my string):

![Image](https://i.imgur.com/9UuRUdM.jpg)

That is, copy the text of A (2-1), B (2-1) and D (2-1) because it has detected the first happines in A2 and then copy the text of A (7-1) , B (7-1) and D (7-1) because it has detected the second happines in A7.

Thanks again.