Copy data from sheet to another sheet in specific way ( modify )

[salmasaied]

Greetings to all the gentlemen experts
I have the following wonderful for Mr. Karedog ... it is very fascinating code

But there is a problem with the application of the code by example
Where the problem lies in the presence heads of merged cells
sheet columns of data that are relevant to the indispensable workbook

I also need to transfer data in the same formats and functions
to the sheet "The final result"

Please, I want
Make the adjustments at the code to tackle the problem of merged cells
and Well as the transfer data in the same formats and functions
Thank you for all the provide assistance
Yours respect and appreciation from me

[karedog]

Please Login or Register  to view this content.

[salmasaied]

Dear sir karedog
Thank you very much, you are worthy of trust and respect
Concerning the repetitive loops
they represent a significant impediment to the speedy implementation of the code
Especially with the many, which sometimes reach 50,000 to statement data
Please
Will, I hope, in modifying another using arrays
I appreciate your valuable time
Greetings to you

[karedog]

No other way. You said :

Make the adjustments at the code to tackle the problem of merged cells
and Well as the transfer data in the same formats and functions

Array can only get cell's value/formula, so the formatting can't be received using array.
The only way to copy the formatting is using range.copy method, and as the consequence, this will be slower than array method.

[salmasaied]

Dear sir karedog
Thank you very much
Greetings to you

[karedog]

You are welcome, greetings.

[salmasaied]

dear friend karedog
You are welcome ...... Question please
Because I want to is my understanding code
Why are not taken to the work of code in the event of a merged cells
The Data Sheet row No. 6 and 7 "column headers addresses"
In the case of Clear rows 6 and 7
You will notice that code works wonderful
Is there a way to tackle code
Greetings to you

[karedog]

I don't understand. We don't deal with anything related to HTML here, there is no HTML code, which HTML code that you referred ?

You can make the macro run faster by adding these 2 lines marked with red :

Please Login or Register  to view this content.

[salmasaied]

dear friend karedog
You are welcome
I do not mean this code
But this code

Please Login or Register  to view this content.

There is something I can not understand this code, although it simple
But it carries with it a wonderful ideas
HTML, this an inadvertent error
please accept my apology
Greetings

[karedog]

Actually it is a simple loop :


We take the current region of cell A8 (source data) values to an array (arr1) :

Please Login or Register  to view this content.

The target range will be bigger than the source data, because there are some blank rows to be inserted, this i variable is calculate the number of final rows of target range :

Please Login or Register  to view this content.

Because we have know how big the target range will be, take this target range formulas to an array (arr2) :

Please Login or Register  to view this content.

Now we do the looping, the p variable is indicating on which row of arr2, the writing will be performed.

Please Login or Register  to view this content.

[salmasaied]

Thank you dear friend karedog
Thus be of friendship
Explain distinct from the a distinct personality
That I could not reach to answer for myself
I'll tell you, but I'll do
Once again thank you very much
You greetings

[karedog]

You are welcome, glad I can help.


Regards