Codes for transpose/copy to another worksheet

[alien3011]

Hi guys,
Anyone can help solve this problem?

What I need to do is transpose a list of data into its own respective worksheet based on data in column c.
For example if column C data is "Place1" the entire row of data will be copied and transpose into "Place1" worksheet.

The below is the code that i am trying to write.

Problem after execution of macro:

It only adds row2 data into the respective worksheet but skip the rest of the data and add the last row data is added in the wrong data worksheet.


I have also attached an example of my working file.

Please Login or Register  to view this content.

[alien3011]

/bump
Posting it up hoping to get reply