Hey guys,
I hope you and your families' health are well and I wish all this nightmare will end soon all around the world.
And I would like ask your help for one VBA my friends.
There are two workbooks: students.xlsx and verify.xlsx
In students.xlsx some cells will be copied from active worksheet, and pasted into verify.xlsx - output.xlsx
1)
Y2:Z2 to A2:B2
AL10:AM10 to C2:D2
BG1:BH3 to E2:J2
2) K2 will be filled with vlookup value. For student A, Z2 value found in BJ16 so BK16 will be copied to K2 cell in output worksheet.
3) And when I run same macro, values should be continued to pasted into same columns in Row 3.
Thanks a lot for your interest guys. Love you all.
Bookmarks