|Thanks for the reply, |
3. "Each cell data is not more than 4 character text ie. 1234 , a234,
ab56, z23 , 999, k2, abc9, abcd if that helps in any way for creating a
macro or any program. "
What would help is if you posted some actual examples of your data. Since what you are asking for is fairly complex, I don't want to waste time working on something that won't work simply because I don't know what your actual data looks like.
Reply to 3 : Lets assume its 4 digits instead of text to make things easier
ie. 1234, 3782 , 4597, 0099 , this will make it a lot easier
to extract & match data.
1 - If a given row of data in Sheet 1 contains e.g. 6 columns, then it only needs to be compared to rows of 6 columns in Sheet 2, correct? In other words:
If Sheet 1 contained A B C D E F then E F A C D B would fit your criteria of a "match" but not A B C D E F G because there are 7 columns in that set.
Is that correct?
Reply to 1 : Yes you are correct, one row containing 6 columns in sheet 1 will
always be compared to only one row of data containing 6 columns in sheet 2.
similarly if for another set of data say contain 10 columns of row data in
sheet 1 will only be compared with 10 columns of row data in sheet 2.
2 : duplicates row matching data not needed if same data is found twice or more in
same worksheet." Since your idea of "matching data" is different than mine,
this is not clear.
If Sheet 1 contained A B C D E F then E F A C D B would fit your criteria of a
"match" and should be "extracted".
Reply to 2 : What can be done is once a match is found it can be extracted and
stored and further matching & extraction process stopped for that row , ie.
check for the new next row of data from sheet 1.
If duplicates show up in the final extracted result sheet ( because sheet 1
may also contain a duplicate ) it can be sorted and filtered.
If this can be done , it would be great as a starter in solving the problem.
Appreciate your time and effort ,
I hope I am clear,