Arpanakumar
Member
Hello Experts team.
i have some requirment where in on click of a button need to move sheets and save it as separate workbooks with specific sheets..i do not want hard coded names it may vary..
Example
File Name Sheet names
FIRST A AA AAA
SECOND B BB BBB
THIRD C
Firstname file to be created with "A" "AA" "AAA" sheets from the master file and so on in a folder.
Please do need full test file attatched
i have some requirment where in on click of a button need to move sheets and save it as separate workbooks with specific sheets..i do not want hard coded names it may vary..
Example
File Name Sheet names
FIRST A AA AAA
SECOND B BB BBB
THIRD C
Firstname file to be created with "A" "AA" "AAA" sheets from the master file and so on in a folder.
Please do need full test file attatched