Import of excel row from 1 excelsheet to another based on vlookup result

[shankardat]

Hi,

I have 1 excel sheet named "UTR.xls" in which each of the rows contains the whole data of each and indivisual objects, each row starts with the object name on its leftmost column. I am looking make a small macro that will import the individual rows to 2nd tab called "result" in another excel sheet named "output.xls" based on the object name that we will enter in the 1st tab called "input" of output.xls.

Thanks in advance to all the experts for their help in this issue.