How to copy the cells from one active sheet to another active sheet

**pranav.y** · 06-05-2013, 09:25 AM

Hi n thanks

i have created templates with given name now on clicking the button it creates different templates what is needed but i want a button on one of the created template which should copY THE CELLS from other template which is also created at the same tym both are active . Should should i copy from that specific active sheet to this active sheet.

EX:
what i have :
BUTTON CLICK - copies and displayes the sheet with the manually given at that time sheetname (upto 4 with different data) so every click it creates new 4 sheets with diff sheetname

now i want to create a button on one of that sheet ex: copy cells from sheet 1 which is active to another sheet2 active

**patel45** · 06-05-2013, 09:38 AM

2 active sheets in the same time ?

**pranav.y** · 06-05-2013, 09:44 AM

no i want to copy from one sheet to another but if i say ... copy to active sheet from (since from sheet is created at the same time this sheet is created by click with another name)

**Norie** · 06-05-2013, 10:02 AM

How are you creating the new sheet and which sheet do you want to copy from?

PS Don't use ActiveSheet, refer to sheets by their name or via an object variable.

**pranav.y** · 06-05-2013, 10:25 AM

Thanks for the reply .....if i say i create a worksheets sheet 1 ,sheet 2 , sheet 3 now for every click it creates the copy of that sheet like sheet 1(1), sheet 2(1), sheet 3(1) ....so if u click again it will create sheet 1(2), sheet 2(2), sheet 3(2) so i want a button in sheet 1(1) which copies a cells from sheet sheet 2(1) and if i click on sheet 1(2) it should copy the cells from sheet 2(2).

**Norie** · 06-05-2013, 11:31 AM

So how are you creating the worksheets?

If you are using code you can create references to the worksheet the button is on and the worksheet you are creating.

You can then use those references to copy data from one worksheet to the other.

**pranav.y** · 06-06-2013, 06:16 AM

ok i got this one now can you please tell me the code like said for every click it generates the copy of the sheet nw one click generates sheet 1(1), sheet 2(1), sheet 3(1) and again a click generates sheet 1(2), sheet 2(2), sheet 3(2) i want the color of the tab for the set of sheets should be same like if i click button it give sheet 1(1), sheet 2(1), sheet 3(1) with tab color - red , another click sheet 1(2), sheet 2(2), sheet 3(2) - tab color blue n so on .....
thanks