VBA Auto Copy to Next Sheet

[blues_oo7]

Happy day to all,

I have some challenge here, i have a voucher template in sheet1,
When i press the button1 i want to auto copy paste the range A1:K25 to New Sheet(same workbook), also i want the sheet name same to the Voucher# located at J2,

Thank YOU in ADVANCE

[teylyn]

Hello blues,

maybe like this:

Please Login or Register  to view this content.

[blues_oo7]

wow this is great, thanks

[blues_oo7]

can you please add a code copy value only, thank you again

[teylyn]

try this, then:

Please Login or Register  to view this content.

[blues_oo7]

Thanks this one is great