Hi Gurus,

is there a possible to copy a worksheet 30 times in the same file. However, when copying the sheet, it would like to name them as 2,4,6,8 and so on and I'd want the paste special function in the copied workbook data for example.

Copied Row A1, D1 from Sheet 2 to 4
Copied Row A1, D1 from Sheet 4 to 6
Copied row A1, D1 from Sheet 6 to 8

so on.

Please can you help me with this.

Thank you so much for your continued help.