Hi, I am not a well versed person in VB. I need a small VB program, that can search for a number in an Excel Sheet on pressing a button. Copy the row containing that number to another sheet. Then on searching again ,copy that row with the new search to the second row of the new sheet and so on. Please help.. It would be a great help as I am doing this now manually which takes Hours