• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy paste macro

vmjan02

New Member
Is there a possibility of copy past from one sheet to another using macros. the data in sheet1 is in vertical way,

IDAbssSCTCC
SourceProcessDtaProcessDtaProcessDtaTotal
a1030545
b1030545
c1030545
d1030545
e1030545
f1030545
g1030545

Were as the data need to be copy in sheet2 in horizontally way, below is the output.
aTCC5
aSC30
aAbss10
Total45
bTCC5
bSC30
bAbss10
Total45

any idea
 
Back
Top