a button to repeat a range of cells and update series number

Hi

I need your help to optimize a code in one sheet of the attached file and create another one in the second sheet.

On sheet (Design1) I wrote a code to make a button to copy a range of cells (site info) and paste it below it with a formula to update the number of site with each new site. The code is working but I am sure that the way a wrote it is very poor, I need your input to make it more effective and smart.
On sheet (sheet2) I have a button that I want it to reproduce the first 10 rows exactly as they are with their color and to extend the series in column A to continue I.e. from 11 to 20 and so on with every click on the button.


Thank you in advance

Emma_B

Hi Emma,
try it

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Wow works like a charm THANKS. However I need another small help, in the first code I need the site adress cell in the new site "site# 2" to be selected. this should be D17 when click the button the first time and D26 when clicking the second time and so on.

in the second code I need the new rows to be empty i.e when create new rows eg. 10 to 20 to not copy the content of rows 1 to 10. and to sellect the last empty cell in column B.

Hope I could explain it well

Emma_B

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Perfect for the first code.
for the second code in "sheet2" I still could not have the cell in column B in the last added row selected. so if I have 10 rows and I add another 10 I need the cell B28 to be selected and if I add another 10 the cell B38 and so on.
Hope I could explain better this time
btw how to give feeback to to your help?

Emma

then so

Please Login or Register  to view this content.

that was awesome thanks a lot