I have a requirement to copy entire sheet through a click on the button. After performing the task if I come back on the original sheet and do some changes to it, then there will not be any impact on copied sheet. If again perform the copy of a sheet, it will create another sheet.
This action I want to perform 6 times. all the copied sheet must carry the selection which was there while copying the sheet.
I tried doing alternate state but could able to do so. Is there any macro through which i can copy the sheet and detach it?
