Hi,
I am new to Excel macro functions, My requirement is Take "Roll No" input from Sheet 1 ; One by one and find matches in Sheet 2; Copy those records in sheet 3;
If the roll no occurs in one or more time all records should be updated in sheet 3.
Can you please help me on Macro to full fill this .
Please help.
Attached: Sample Excel file
Rgds
Bookmarks