Copy Template Workbook and paste specifc range

Hello everybody
I have two workbooks : "Copy Workbook Template" this is the main workbook and "Template" workbook
I intend to copy the template workbook and name it according to the values in column C

Please Login or Register  to view this content.

That's my working code except for this line

Please Login or Register  to view this content.

Everything is ok .. I need to copy the range from column B to column P according to the suitable row
the copied range from the main workbook to be pasted in the range("B3:B17") in the new copied workbook

Here' an attachment that illustrates my requirement

I just need to copy the range related to every row to he new copied workbook to range("B3:B17")

My brothers
Just one line to be edited .. I tried every possible combination for me but I failed

I thought it is easy but after many tries I failed and I can't figure it out
please help me

The array you are referencing is one of values, not ranges, so you can't use it that way.

Hi,

When you use this statement :

Please Login or Register  to view this content.

the values of Arr variable is "a copy" values of range A1:S5, not the range object itself (for example if you try run this statement: Debug.Print Arr.Address, will raise an error, because Arr is not a range object, but "a copy" values of the range)

So after above statement, the values of Arr are :

Please Login or Register  to view this content.

So this statement :

Please Login or Register  to view this content.

is completely error, the parameter for the .cells() is numbers which point to row and column of target cell, so it must be something like :
.Cells(5, 1)
.Cells(2, 3)
etc

but you try to put :
.Cells(Arr(I, 2))
which is :
.Cells("Emp No-1")
so this is error, you don't provide two numeric values, which are the row number and the column number

You previously have made a copy of source range to Arr variable, so it is not needed to retrieve the values from the source range anymore (using .cells() or .range()), but use the Arr instead.
The values that need to returned is a small part of the big array, so I make a smaller array (named ArrPart) to get the needed values using this code:

Please Login or Register  to view this content.

and then put this ArrPart to target range.

Please Login or Register  to view this content.

Regards

This modification seems to work:

Please Login or Register  to view this content.

Mr. Karedog
Mr. Arkadi
Thank you very much for these great solutions and for the valuable information you provided
Thanks a lot