Copy Format and Data

Hi all,

I am trying to copy format and data from different worksheet.

I have no issue on copying the format from "Template" sheet but having problem copying data from other sheet matching the column once the format have been completed.

The idea is to

1 - copy format from template
2 - copy data fill in template based on column criteria

Example code

Please Login or Register  to view this content.

xxxxxx is where i hope to put the code so it does loop and copy the data into the newly created sheet.

Thanks in advance

no help?