A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3577

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: geshi/geshi.php

Line Number: 3469

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /www/wwwroot/pastebin.pl/system/core/Exceptions.php:185)

Filename: view/download.php

Line Number: 2

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /www/wwwroot/pastebin.pl/system/core/Exceptions.php:185)

Filename: view/download.php

Line Number: 3

Dim filePathSource As String Dim filePathTarget As String Dim namePathSource As String Dim checkedValues As String Dim columnCheckFromSource As String Dim titleSheetSourceString As String Dim titleSheetTargetString As String Private Sub ComboBox1_Change() Dim wb As Workbook Dim ws As Worksheet Dim lastCol As Integer Dim i As Integer Dim selectedColumn As String Dim selectedSheet As String selectedSheet = ComboBox1.Value titleSheetSource.Caption = selectedSheet titleSheetSourceString = titleSheetSource.Caption Set wb = Workbooks.Open(filePathSource) For Each ws In wb.Sheets If ws.Name = selectedSheet Then lastCol = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column ComboBox2.Clear For i = 1 To lastCol ComboBox2.AddItem ws.Cells(1, i).Value Next i Exit For End If Next ws End Sub Private Sub ComboBox2_Change() Dim selectedData As String columnCheckFromSource = ComboBox2.Value sourceOriginalColumn = ComboBox2.Value confirmDataSource.Enabled = True End Sub Sub RemoveExistingCheckBoxes() Dim ctrl As MSForms.Control For Each ctrl In Me.Controls If TypeOf ctrl Is MSForms.CheckBox Then Me.Controls.Remove ctrl.Name End If Next ctrl End Sub Private Sub ComboBox3_Change() On Error GoTo ErrorHandler Debug.Print "Start ComboBox3_Change()" Dim wb1 As Workbook Dim wb2 As Workbook Dim ws1 As Worksheet Dim ws2 As Worksheet Dim lastCol1 As Integer Dim lastCol2 As Integer Dim col1 As Integer Dim colName As String Dim selectedSheet As String Dim columnSourceFound As Boolean Debug.Print "Getting selected sheet..." selectedSheet = ComboBox3.Value titleSheetTarget.Caption = selectedSheet titleSheetTargetString = titleSheetTarget.Caption If selectedSheet = "" Then Exit Sub ' Ki?m tra giá tr? h?p l? c?a selectedSheet Debug.Print "Opening workbooks..." Set wb1 = Workbooks.Open(filePathSource) Set wb2 = Workbooks.Open(filePathTarget) Debug.Print "Initializing worksheets..." Set ws1 = Nothing Set ws2 = Nothing For Each ws In wb1.Sheets If ws.Name = titleSheetSourceString Then Set ws1 = ws Exit For End If Next ws For Each ws In wb2.Sheets If ws.Name = titleSheetTargetString Then Set ws2 = ws Exit For End If Next ws If ws1 Is Nothing Or ws2 Is Nothing Then MsgBox "Failed to access sheets." Exit Sub End If Debug.Print "Getting last columns..." lastCol1 = ws1.Cells(1, ws1.Columns.Count).End(xlToLeft).Column lastCol2 = ws2.Cells(1, ws2.Columns.Count).End(xlToLeft).Column columnSourceFound = False Debug.Print "Removing existing checkboxes..." RemoveExistingCheckBoxes ' Xóa checkbox hi?n có For col1 = 1 To lastCol1 colName = ws1.Cells(1, col1).Value Debug.Print "Processing column: " & col1 & ", Name: " & colName If WorksheetFunction.CountIf(ws2.Rows(1), colName) > 0 Then If colName = columnCheckFromSource Then columnSourceFound = True Debug.Print "Creating checkbox for column: " & col1 & ", Name: " & colName Dim newCheckbox As MSForms.CheckBox Set newCheckbox = Me.Controls.Add("Forms.CheckBox.1", "CheckBox_" & col1, True) With newCheckbox .Caption = colName .Value = False .Width = 100 .Height = 18 .Left = 335 .Top = (col1 - 1) * 20 + 70 ' Ð?t giá tr? c?a Top d?a trên giá tr? c?a col1 .Font.Size = 10 End With End If Next col1 If columnSourceFound = False Then MsgBox "Not found an original column" Exit Sub ErrorHandler: Debug.Print "Error: " & Err.Description Debug.Print "Error occurred at line: " & Erl HandleError Err.Description End Sub Sub HandleError(errorMessage As String) Dim errorLocation As String errorLocation = "Error occurred in at line " & Erl & vbCrLf MsgBox "Error: " & errorMessage & vbCrLf & errorLocation, vbCritical End Sub Private Sub Label1_Click() End Sub Private Sub CommandButton3_Click() ResetForm End Sub Private Sub ResetForm() ' Xóa d? li?u trong các ComboBox ComboBox1.Clear ComboBox2.Clear ComboBox3.Clear ' Reset các bi?n du?ng d?n filePathSource = "" filePathTarget = "" checkedValues = "" ' Reset các nhãn tiêu d? titleFilePathSource.Caption = "" titleFilePathTarget.Caption = "" titleSheetSource.Caption = "" titleSheetTarget.Caption = "" ' Vô hi?u hóa CommandButton2 và ComboBox3 CommandButton2.Enabled = False ComboBox3.Enabled = False ' Vô hi?u hóa nút confirmDataSource confirmDataSource.Enabled = False ' Vô hi?u hóa các ô checkbox RemoveExistingCheckBoxes ' Vô hi?u hóa các di?u khi?n khác n?u c?n CommandButton1.Enabled = True ComboBox1.Enabled = True ComboBox2.Enabled = True End Sub Function FindColumn(ws As Worksheet, header As String) As Integer Dim i As Integer For i = 1 To ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column If ws.Cells(1, i).Value = header Then FindColumn = i Exit Function End If Next i End Function Private Sub confirmDataSource_Click() CommandButton1.Enabled = False ComboBox1.Enabled = False ComboBox2.Enabled = False CommandButton2.Enabled = True ComboBox3.Enabled = True End Sub Private Sub sourceOriginalColumn_Click() End Sub Private Sub titleSheetSource_Click() End Sub Private Sub titleSheetTarget_Click() End Sub Private Sub UserForm_Click() End Sub Private Sub UserForm_Initialize() CommandButton2.Enabled = False ComboBox3.Enabled = False confirmDataSource.Enabled = False End Sub Function GetCheckedValues() As String Dim ctrl As Control Dim checkedValues As String ' Kh?i t?o chu?i checkedValues = "" ' Duy?t qua t?t c? các control trên form For Each ctrl In Me.Controls ' Ki?m tra n?u control là checkbox If TypeOf ctrl Is MSForms.CheckBox Then ' Ki?m tra n?u checkbox du?c dánh d?u True và không ph?i là checkbox có tên là columnCheckFromSource If ctrl.Value = True And ctrl.Caption <> columnCheckFromSource Then ' Thêm tên c?a checkbox vào chu?i checkedValues checkedValues = checkedValues & ctrl.Caption & "," End If End If Next ctrl ' Lo?i b? d?u ',' cu?i cùng n?u có If Len(checkedValues) > 0 Then checkedValues = Left(checkedValues, Len(checkedValues) - 1) End If ' Tr? v? chu?i k?t qu? GetCheckedValues = checkedValues End Function Private Sub CommandButton1_Click() Dim fd As FileDialog Dim wb As Workbook Dim ws As Worksheet Dim lastCol As Integer Dim i As Integer Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd .Title = "Ch?n File Excel" .AllowMultiSelect = False .Filters.Clear .Filters.Add "Excel Files", "*.xlsx; *.xls; *.xlsm" If .Show = -1 Then filePathSource = .SelectedItems(1) titleFilePathSource.Caption = filePathSource Set wb = Application.Workbooks.Open(filePathSource, UpdateLinks:=False, ReadOnly:=True) Dim sheetNames() As String ReDim sheetNames(1 To wb.Sheets.Count) For i = 1 To wb.Sheets.Count sheetNames(i) = wb.Sheets(i).Name Next i With ComboBox1 .Clear .List = sheetNames End With End If End With End Sub Private Sub CommandButton2_Click() Dim fd As FileDialog Dim wb As Workbook Dim ws As Worksheet Dim lastCol As Integer Dim i As Integer Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd .Title = "Ch?n File Excel" .AllowMultiSelect = False .Filters.Clear .Filters.Add "Excel Files", "*.xlsx; *.xls; *.xlsm" If .Show = -1 Then filePathTarget = .SelectedItems(1) titleFilePathTarget.Caption = filePathTarget Set wb = Application.Workbooks.Open(filePathTarget, False, True) ' M? workbook không hi?n th?, ch? d?c Dim sheetNames() As String ReDim sheetNames(1 To wb.Sheets.Count) For i = 1 To wb.Sheets.Count sheetNames(i) = wb.Sheets(i).Name Next i With ComboBox3 .Clear .List = sheetNames End With End If End With End Sub Private Sub CommandButton4_Click() Dim ws1 As Worksheet Dim ws2 As Worksheet Dim lastRow1 As Long Dim lastRow2 As Long Dim i As Long, j As Long Dim searchColumn1 As Integer ' V? trí c?a c?t c?n tìm trong Sheet1 Dim searchColumn2 As Integer ' V? trí c?a c?t c?n tìm trong Sheet2 ' M? workbook ngu?n và workbook dích Set ws1 = Workbooks.Open(filePathSource).Sheets(titleSheetSource.Caption) Set ws2 = Workbooks.Open(filePathTarget).Sheets(titleSheetTarget.Caption) Debug.Print "Opened source workbook and sheet: " & filePathSource & ", " & titleSheetSource.Caption Debug.Print "Opened target workbook and sheet: " & filePathTarget & ", " & titleSheetTarget.Caption ' Tìm s? dòng cu?i cùng c?a m?i sheet lastRow1 = ws1.Cells(ws1.Rows.Count, "A").End(xlUp).Row lastRow2 = ws2.Cells(ws2.Rows.Count, "A").End(xlUp).Row Debug.Print "Last row in source sheet: " & lastRow1 Debug.Print "Last row in target sheet: " & lastRow2 ' Xác d?nh v? trí c?a c?t c?n tìm trong Sheet1 và Sheet2 searchColumn1 = FindColumn(ws1, columnCheckFromSource) searchColumn2 = FindColumn(ws2, columnCheckFromSource) Debug.Print "Search column in source sheet: " & searchColumn1 Debug.Print "Search column in target sheet: " & searchColumn2 ' L?y danh sách các header du?c ch?n Dim headers As String Dim headerArray() As String Dim positionString As String Dim countString As String Dim cell As Range headers = GetCheckedValues() headerArray = Split(headers, ",") ' Tìm v? trí c?a các header trong Sheet1 For i = LBound(headerArray) To UBound(headerArray) Set cell = ws1.Rows(1).Find(headerArray(i), LookIn:=xlValues, lookat:=xlWhole) If Not cell Is Nothing Then positionString = positionString & cell.Address & "," Debug.Print "Header '" & headerArray(i) & "' found in source sheet at position: " & cell.Address Else Debug.Print "Header '" & headerArray(i) & "' not found in source sheet." End If Next i ' Ki?m tra có tiêu d? nào không t?n t?i trong Sheet1 không If Len(positionString) = 0 Then Debug.Print "None of the selected headers found in source sheet. Exiting." Exit Sub End If ' Xóa d?u ph?y cu?i cùng positionString = Left(positionString, Len(positionString) - 1) ' S? lu?ng header countString = UBound(headerArray) - LBound(headerArray) + 1 ' Tìm v? trí c?a các header trong Sheet2 Dim positionStringTarget As String Dim countStringTarget As String For i = LBound(headerArray) To UBound(headerArray) Set cell = ws2.Rows(1).Find(headerArray(i), LookIn:=xlValues, lookat:=xlWhole) If Not cell Is Nothing Then positionStringTarget = positionStringTarget & cell.Address & "," Debug.Print "Header '" & headerArray(i) & "' found in target sheet at position: " & cell.Address Else Debug.Print "Header '" & headerArray(i) & "' not found in target sheet." End If Next i ' Ki?m tra có tiêu d? nào không t?n t?i trong Sheet2 không If Len(positionStringTarget) = 0 Then Debug.Print "None of the selected headers found in target sheet. Exiting." Exit Sub End If ' Xóa d?u ph?y cu?i cùng positionStringTarget = Left(positionStringTarget, Len(positionStringTarget) - 1) ' S? lu?ng header trong Sheet2 countStringTarget = UBound(headerArray) - LBound(headerArray) + 1 ' Chuy?n v? trí các header thành m?ng Dim positionsA() As String Dim positionsB() As String positionsA = Split(positionString, ",") positionsB = Split(positionStringTarget, ",") ' Copy d? li?u t? Sheet2 sang Sheet1 ' Copy d? li?u t? Sheet2 sang Sheet1 ' Copy d? li?u t? Sheet2 sang Sheet1 searchColumn1 = FindColumn(ws1, columnCheckFromSource) searchColumn2 = FindColumn(ws2, columnCheckFromSource) Dim foundRow As Range ' L?p qua t?ng hàng trong t?p A For i = 2 To lastRow1 ' Tìm giá tr? tuong ?ng trong searchColumn2 c?a t?p B Set foundRow = ws2.Columns(searchColumn2).Find(ws1.Cells(i, searchColumn1).Value, LookIn:=xlValues, lookat:=xlWhole) ' N?u tìm th?y giá tr? If Not foundRow Is Nothing Then ' L?p qua t?ng v? trí c?n map trong Sheet1 và Sheet2 For j = LBound(positionsA) To UBound(positionsA) ' Ki?m tra v? trí có h?p l? không If InStr(1, positionsA(j), "$") > 0 And InStr(1, positionsB(j), "$") > 0 Then ' L?y ch? m?c c?t t? v? trí Dim columnA As Long Dim columnB As Long columnA = Range(positionsA(j)).Column columnB = Range(positionsB(j)).Column ' Gán giá tr? c?a ô t? Sheet2 sang Sheet1 ws1.Cells(i, columnA).Value = ws2.Cells(foundRow.Row, columnB).Value Debug.Print "Value copied from " & ws2.Name & " " & ws2.Cells(foundRow.Row, columnB).Address & " to " & ws1.Name & " " & ws1.Cells(i, columnA).Address Else Debug.Print "Invalid position for header '" & headerArray(j) & "' in either source or target sheet." End If Next j Else Debug.Print "Value not found in " & ws2.Name & " for searchColumn2 value: " & ws1.Cells(i, searchColumn1).Value End If Next i ws1.Parent.Save ' Luu ws1 ' Luu workbook hi?n t?i ThisWorkbook.Save ' Ðóng workbook sau khi dã x? lý d? li?u ws1.Parent.Close False ws2.Parent.Close False Exit Sub ' Thoát kh?i hàm n?u không có l?i End Sub Function GenerateRandomSheetName() As String Dim sheetName As String Dim ws As Worksheet Dim nameExists As Boolean Randomize ' Kh?i t?o b? sinh s? ng?u nhiên ' L?p cho d?n khi tìm th?y m?t tên sheet chua du?c s? d?ng Do ' T?o tên sheet ng?u nhiên sheetName = "Sheet_" & Int((10000 * Rnd) + 1) nameExists = False ' Ð?t c? ki?m tra tên t?n t?i thành False ' Ki?m tra xem tên dã t?n t?i trong workbook chua For Each ws In ThisWorkbook.Sheets If ws.Name = sheetName Then nameExists = True Exit For ' Thoát kh?i vòng l?p khi tìm th?y tên dã t?n t?i End If Next ws Loop While nameExists ' L?p l?i quá trình n?u tên dã t?n t?i GenerateRandomSheetName = sheetName ' Tr? v? tên sheet ng?u nhiên End Function