Macro to copy sheets

[kent97]

Hi all,

ScreenHunter_004.jpg

I want a macro,

1. Copy A4 to C2
2. Copy Sheet1 to a new sheet, and rename it as the content at C2, in this case "17 05"
3. Goto sheet "17 05", copy cells D2:E2 and paste only the values onto the same cells, ignore the formula. In this case 6 and 18.
4. Return to Sheet1, look down next value "17 04" and do the same as above.
5. The macro stops when it detects nothing at A7.

Thanks

[sintek]

Hi Kent97

Is this what you are after?

Please Login or Register  to view this content.

[kent97]

Hi sintek,

The macro stop with error message "variable not defined"

ScreenHunter_008.jpg

[sintek]

In your sample...the Main sheet is sheet1...Right.
Try with amended code in Post 2

[kent97]

Thank you sintek, the amended code is perfect.

[sintek]

Glad i could help...Thanks for rep +