Hi, i am having 2 worksheets where from sheet TRS under product colum there are values which needs to be found one by one in sheet AP and if found need to copy the value highlighted in yellow and paste in sheet TRS under column offshore file. Want to creat a loop for this search. I have attached the screenshot for the reference. It will be great help thank you.
How to find the values in all the cells from one sheet to other sheet and paste if found
- Rohie
- Thread is marked as Resolved.
-
-
-
Images don't help. Attach an example workbook with a better explanation of what you want to do.
-
Hi, i have attached the excel workbook. it has 2 sheets. the requirement is copy the product id from sheet TRS and search in sheet AP and if found copy the value present under that number highlighted in yellow and paste it in sheet TRS under offshore column. i want to loop this until the product id is finished using VBA.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!