Hi Friends,
From past 2 days I been trying to extract multiple occurrences present in "cell text"(sheet1 ColumnA:A) and extract into sheet2 and sheet3.
Cross match with IDs between sheet2 data with sheet3 and extract matched data into sheet4(Macro 3 final results).
I have attached sample data file with results in sheet2(macro 1) sheet3(macro 2) and results in Macro 3 final results.
Each cell contains number of occurrences will get changed every time when I change cell data. So, looping all occurrences would be good as per my knowledge.
https://spaces.hightail.com/space/ykSpZ74qby
From past 2 days I been trying to extract multiple occurrences present in "cell text"(sheet1 ColumnA:A) and extract into sheet2 and sheet3.
Cross match with IDs between sheet2 data with sheet3 and extract matched data into sheet4(Macro 3 final results).
I have attached sample data file with results in sheet2(macro 1) sheet3(macro 2) and results in Macro 3 final results.
Each cell contains number of occurrences will get changed every time when I change cell data. So, looping all occurrences would be good as per my knowledge.
https://spaces.hightail.com/space/ykSpZ74qby
