Avinash Singh
asked on
Copy and paste the data based on sheet2 Conditional
If coloumn A and Coloumn C of sheet2 are same then copy the data of sheeet1 of same row and paste the data to sheet3
If Coloumn A and Coloumn B of sheet2 are same then copy the data of sheeet1 of same row and paste the data to sheet4
Highlighted colour is only for understanding purpose,In actual file there is no highlighted colour
I have to do all this by vba
sample-file-001.xlsm
If Coloumn A and Coloumn B of sheet2 are same then copy the data of sheeet1 of same row and paste the data to sheet4
Highlighted colour is only for understanding purpose,In actual file there is no highlighted colour
I have to do all this by vba
sample-file-001.xlsm
ASKER
I am not looking for formula, I am looking for vba to solve my problem
ASKER
Any doubts reg this post ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thnx LET for giving ur precious time and great support to this post
Here is something that will give you an idea, please use it, just place the formula where you want the text to be not colors. It will work.
IF(OR(A2=C2,A2=B2),Sheet1!
Regards
Chris