Since I have not received any responses to this post, I have come up with an alternative approach to resolve my problem. But I still have the same old problem of not having skills to program what I need. Hopefully, someone will respond with a solution for the following requirement.

I have one column of data that I want to Find or Search for a text “xxxxx”. After this text is found, I want to go the NEXT ROW and sent the data in that NEXT ROW cell to cell “A1” on the same worksheet. If there is no data in that NEXT ROW, send text string “not found” to cell “A1”of that same worksheet. Thanks in advance for any help regarding this.