i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to separate worksheet in the same workbook(abc123.xlsm). now the next thing is I want to create a common command button which moves data of each sheet into different excels files(could be named as target1.xlsx , target2.xlsx, target3.xlsx . . . . . . .. up to target10.xlsx). all target files are available in different folder named as "track". i am unable to create a vba code for that command button .
the thing that command button should do is :
" open target file then move data then save and then close the target file "