Nested Loop problem/Algorithm

I am comparing two columns from different sheets in the same workbook. If a match is found, I want to copy the data and paste it to a different sheet in the same workbook. But there are certain conditions that I have to account for when I perform copying and pasting


Please open my workbook in attachments and have a look at it


1)I want to first go to sheet1, pick an entry from columnB and then compare that entry with the entries of column B in the connections Sheet.

2)When it hits the First match, I want to copy the matched row and copy all rows till string "Name" appears in column A of the connection Sheet

3)Paste the copied data on to the sheet 2

4)Now I want to check if the value of the cell in column B of sheet connection contains a string which is present in the current entry of column B of sheet 1

5)if it does then copy everything till next Name in column A(this step continues until condition 6 gets true)

6)If not then the go back to Step 1


I am not a computer programmer, but I have tried writing a code after reading posts on the forum. I am anxiously looking for all of your replies

Please Login or Register  to view this content.