Transpose data to another sheet using macro

[geliedee]

Hi All,

I have here a working file. The code i have embedded successfully transfer all the data to another sheet.

However, its doesn't capture the duplicate parts like from column F to K, it should be transpose everything to the Validation Sheet.


And the data from column U to Z from MFD RAW DATA DUMP should be tranpose to: Validation Sheet AC to AH column.

Can anybody help me with this?I badly needed the file since i have to check manually those hundreds of customers

Attached is the file..

[geliedee]

Any body can help?

[watersev]

hi there, unless you provide clear instructions I guess nobody can help on it including me. Providing required output on a sample data would be helpful as well.

[damp]

I agree with watersev.

[geliedee]

Hi All,

What i need is just to copy all the data from MFD RAW DATA DUMP column A to U to Validation Sheet column A to U.
No need for data filtering i just need to copy all the data to perform another steps..

And for the MFD RAW DATA DUMP Column V to AA, it should be copied to Validation Sheet AC to AH.

Attached is the desired output...

[watersev]

option:

Please Login or Register  to view this content.

[geliedee]

Wow!! Thanks alot! I'm so sorry for disturbing you
Just one last favor.. How can i add a msg bos if this the MFD Raw data dump then it has to have a message saying its blank

[watersev]

Please Login or Register  to view this content.