I would be really happy if someone helps me with this macro. I have 4 columns: A, B, K, L.
A and B are full of data (thousands of rows) in K there are key words (about 10 but this number vary). I need macro, which will check word in K (for example K3) and then it will run through column A and if there is match (e.g. A200) then it will copy data from cell next to it (B200) and then it will paste it to L column (L3). Afterward it checks K4, K5....
This would save me literally hundreds hours of my time. Thanks a lot!