Copy data from one worksheet to another worksheet by macro/vba

Hi,

I have a problem hope anyone can help me. Actually, I have an excel sheet in which first worksheet contains 113 columns. On a daily basis, we need to fill some data on the second worksheet. So what I want is that data from worksheet first automatically copied to second worksheet basis on a particular criteria. For example, if I enter the person's name on the second worksheet say in cell D1 the macro should look for that name in first worksheet and then copied the data of say A1 to K1 to same cell range of second worksheet. Same will repeat for second row and so on.

Crosspost:- http://www.mrexcel.com/forum/excel-q...lications.html