Copying Vertical File to Horizontal File

[Jarvin24]

Greetings,

I have this working file which eventually I have to change to a specific format be accepted by our system.

What I always do is to Copy and Paste their values into the next sheet to their respective columns.

Scenario:
Column A and B = FIXED
Column C and D = May vary or change depending on how many Year is involved.
Only Cells with values are copied and transferred to the EDI (other Sheet).

Hope someone could help me on this.. So I could spend more time on other things

[antoka05]

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

[rcm]

try this code

[Jarvin24]

Awwww.. SUper Duper Thank you..

Now What I'm gonna do is to learn this codes and understand it.. ^_^

Unbelievable... Wow