Hello there, I would like to seek help and advice how can I do it on vba code; I have to find certain word and when it found it will start to copy,start from the found word until the last cell who have data and paste it on another sheet.Is it possible?hope I can get response on this.thanks in advance