Would be grateful if one could help me with a code for this situation I am facing with daily:



- Bilingual excel files with thousands of lines
- I need to show only the text from column A that corresponds(by row) to the red text from B or to extract it separately.
- Now I manually hide everything except this needed text.


This is a very tedious job on a daily basis. So a code to extract just the text mentioned above from A(by color in B) and place it in B(override) or into another column, but necessarily at the same position, same line as in A, would be heaven

Or a code to automatically hide everything except that needed text would be also awesome

Thanks!

Attached Files

test.xlsx (9.0 KB, 11 views)