Copy values from worksheet and paste to starting from 15th row.

[turist]

I am using this code which found in iternet.No problem when using, working very well.
It is copying the values from "DATA" sheet and pasting to starting from 2nd row of new opened sheets(Sayfa).
But, I want to paste the the values to new sheets(Sayfa) 15th row to be opened by macro, from "DATA"sheet.

How can I change this codes to make 15th row?

Thanks for any reply and help.

Regards,
turist

Please Login or Register  to view this content.

[AB33]

untested

Please Login or Register  to view this content.

[turist]

Dear AB33,
Thanks for prompt reply.
Not exactly worked. Pasted Starting from 15th row, but NOT continued the next rows.(only ONE row pasted)

[AB33]

If it is not continuous what is this line is doing?

Please Login or Register  to view this content.

You can replace this line

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[turist]

If it is not continuous what is this line is doing?

Please Login or Register  to view this content.

You can replace this line

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Replaced ,but now;
1st Sayfa starting from 15th row and continue,
2ndSayfa starting from 22th row and continue,
3rdSayfa starting from 27th row and continue,

[AB33]

I do not know what do you want to do once the code copies in to row15. What is next? If there is no next, remove the second line and just use once.
Use this line before the loop starts
sira = 15

[turist]

I do not know what do you want to do once the code copies in to row15. What is next? If there is no next, remove the second line and just use once.
Use this line before the loop starts
sira = 15

Thanks a lot for your kind interest and help.
Could you please see attached file?
You can see what is wanted.

[AB33]

Try the attached.

[turist]

Try the attached.

Dear AB33,
Really thanks a lot for your support.I don't want disturb you with my problem.
New code is running starting from 15th row, it is OK.

But,now ; DRAFT sheet (which is template for DATA1, DATA2 and DATA3 sheets) format and headings is missing in opened sheets(at DATA1,2,3).
How can it be replaced ?

Regards,
turist

[AB33]

I am not sure if I understand the role of sheet Daft.
I thought you are creating tabs based on column A of sheet Data, copying starting from row 15.
I removed the code you had as it has to go to function.
What is the function of sheet Daft? Once I know the answer, I will adjust the code.

[nilem]

Hi turist,
maybe so

Please Login or Register  to view this content.

[AB33]

I have added the draft format to be copied in to each sheet.

[turist]

Hi turist,
maybe so

Please Login or Register  to view this content.

Dear nilem,
Thanks for reply. OK, worked.
But I need only B, C, D and J, K columns NOT all columns ( E,F,G,H and I columns should be excluded). Colored in DATA sheet.
Only this columns should go to DATA1, 2,3..... sheets.

Can you fix in that way please?
Regards,
turist

[AB33]

The code you have work- just adjusted few lines. Did you try my last attachment?

[turist]

The code you have work- just adjusted few lines. Did you try my last attachment?

GOam macro is taking DRAFT template, starting from 15th row. OK.

If macro run once , no problem. But run twice there is an error
at:

Please Login or Register  to view this content.

line.