i totally new to this VB. and also macro in excel.
i need to do basically searching copy and paste.
for example
enter name to active cell then the macro will search for the name and copy all the data.on other sheet then patse to the active sheet
please any body can help me