Hi, in this video i have explained that how to save data from one sheet to another sheet in excel via Macro Function, So i have taken the Passport Application form data in excel to make it understand. so watch this video and learn.
Watch This Video to Learn
Please send vba 6 excel file to me