Hi Everybody,
I needed help on the below :
I want to copy a sheet Example (" Main_1") and paste the sheet according to number entered in a cell example in Cell "C3". and rename every copy sheet as Main_2, Main_3 , etc.
like :
if in cell C3 value entered is 4 therefore the Sheet "Main_1" will be copy and paste 4 times and will be rename Main_2, Main_3, Main_4.
Can someone please guide me on that . i try to record a macro to do it but it copies it on fix time that is if recorded to copy 2 times everytime it run it copy only on 2 times.
I have attached my sample file here.
Many thanks in advance.
:confused2:
I needed help on the below :
I want to copy a sheet Example (" Main_1") and paste the sheet according to number entered in a cell example in Cell "C3". and rename every copy sheet as Main_2, Main_3 , etc.
like :
if in cell C3 value entered is 4 therefore the Sheet "Main_1" will be copy and paste 4 times and will be rename Main_2, Main_3, Main_4.
Can someone please guide me on that . i try to record a macro to do it but it copies it on fix time that is if recorded to copy 2 times everytime it run it copy only on 2 times.
I have attached my sample file here.
Many thanks in advance.
:confused2: