fari1
Active Member
- Joined
- May 29, 2011
- Messages
- 362
hi experts,
i've two sheets, my sheet1 has many summary statements of a my official documents and my sheet2 has two columns.
Both of the columns contain text strings,what i want is to match any row of column1 of sheet2 with any row of column1 of the sheet1,if matched,then match the column2 of sheet2 with any row of sheet2,when both of the columns gets matched with 2 rows of the sheet1,then i want to copy the data in between them including the both rows.
i hope i didn't confuse,if anyone wants to help,i can post a sample workbook, thanking u in advance
i've two sheets, my sheet1 has many summary statements of a my official documents and my sheet2 has two columns.
Both of the columns contain text strings,what i want is to match any row of column1 of sheet2 with any row of column1 of the sheet1,if matched,then match the column2 of sheet2 with any row of sheet2,when both of the columns gets matched with 2 rows of the sheet1,then i want to copy the data in between them including the both rows.
i hope i didn't confuse,if anyone wants to help,i can post a sample workbook, thanking u in advance
