VBA Loop

[fari1]

Hi Experts,

i need help with this code.
i've two columns each cell contains text strings, i want to match both of these text strings in another sheet and and copy data in between them.
any help please!

 

[FishingIsMoreFun]

An example of the strings would be good, format etc.

 

[fari1]

if u could provide me with an email id, i can post u a workbook, that would be quiet helpful

 

[fari1]

i can explain u here as well,let me create an example

 

[fari1]

i've two sheets, sheet1 contains text strings in column A, every cell contains text strings.
sheet2 contains two columns,each column contains text strings,i want the code to loop through first column A of sheet2 and match that text string with sheet2 and then match the column B any text string with sheet1,if both of the strings get matched,then copy all the rows in between them.
e.g
in column A of sheet 2 contains "high up the mountains" "high up the roads" "high above clouds" in each cell down the column(it can be many more). i want to match each of this text string in sheet1
and now in column B contains "climb the mountains" drive very fast" "fly in the air".
then i want to match first column A in sheet1 and then column B in sheet1 and copy all the rows in between.

hope i made it clear

 

[FishingIsMoreFun]

Sorry I can't really grasp what you mean.
Its late here, I wouldn't have time to go through the workbook.

I suggest you post an example.

cheers