Hi. Here is the scenario I would like to get help:

column A: has bunch of data or info. I am looking for specific words like BEG. Once I located the BEG I would like to copy only the cell below it where it says PO1 (there may be 2 or 3 cells that contain PO1 - I would like to put them in Column B next to BEG. Each BEG should have PO1 info beside it (Column B). Please help. Thank you.