Need a Code to Copy data from Sheet 1 and Paste to Sheet 2

Hi,

I want such a code which should copy this range from sheet1 BN1:EQ1442 and then it should open a new sheet (sheet2) and paste this copied data in this sheet 2.
This code should paste this copied data into the same cells as it was on sheet1.
While pasting, cell Format should remain same.
Formulas should also remain same as they were on sheet1

When i again Run this code then it should again copy this range from sheet1 BN1:EQ1442 and then it should open a new sheet (sheet3) and paste this copied data in this sheet 3. Same way, When i again Run this code then it should again copy this range from sheet1 BN1:EQ1442 and then it should open a new sheet (sheet4) and paste this copied data in this sheet 4. And so on,

Sample file is attached for more clarification

Is this how you want?

Please Login or Register  to view this content.

Hi Sir jindon,

Thanks a lot Sir. It worked exactly like what i wanted. Thank you so much