Fouko
New member
- Joined
- Feb 8, 2012
- Messages
- 5
- Reaction score
- 0
- Points
- 0
Hi everyone,
I have "Sheet1" and "Sheet2"
In need to add a VBA for conditional cell copy like this :
IF Sheet1 (Cell"A23") = Sheet2 (a cell in Column"A") THEN copy the "Sheet2" same line cell from column B TO Sheet1("B2")
To be clear :
IF Sheet1 (Cell"A23") = Text_To_Find
SEARCH in Sheet2 (a cell in Column"A") = Text_To_Find (ex: A12)
THEN Copy B12 TO Sheet1 (Cell"B2")
Hope my explanations are clear.
Thanks a lot
Fouko
I have "Sheet1" and "Sheet2"
In need to add a VBA for conditional cell copy like this :
IF Sheet1 (Cell"A23") = Sheet2 (a cell in Column"A") THEN copy the "Sheet2" same line cell from column B TO Sheet1("B2")
To be clear :
IF Sheet1 (Cell"A23") = Text_To_Find
SEARCH in Sheet2 (a cell in Column"A") = Text_To_Find (ex: A12)
THEN Copy B12 TO Sheet1 (Cell"B2")
Hope my explanations are clear.
Thanks a lot
Fouko