
anbu - 2011-12-07 23:30:41
I have a excel source file in hand, which is having 3 sheets of data (say example: Test1, Test2 and test3), Now I need to create the 4th sheet|(say example: Test3(1) or Test4) which should be the duplicate/ copy of Sheet #3 (why we go for COPY option is, because all the sheet are developed using macro coding for implement some set of calculation). Here I would request you, if any one can help to COPY the SHEET and create the new sheet as dynamic, also we need to EDIT the sheet data.