macro to find matching value in workbook and pasting it to another workbook

[aman2059]

Hi, could anybody please help with macros for the attached sheets. Right now, i am able to do vlookup to find the values and getting it in the new sheet, is there any way to create a macro for this? So that i can get values in my old workbook on one click to the new workbook. Please find the attached sheet - I have done Vlookup in FILE_080914(New file) from the FILE_080814(Old file). You will find details in the sheet.

All i want is, all data matching to security id from old workbook to new workbook. Please check file.

Thanks alot.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[aman2059]

It's working. will check on my project, if i will find any difficulty, will let you know. thank you so much.