VBA Code to Match the Value from Sheet1 Row 6

  • Taking a look at the Results in your Sheet PasteData ....


    It looks like :


    1. you have only dealt with the Account 00202_0000


    2. there is no Sum over the Data of all 'Gross Wage' rows ... but ONLY Transpose and Copy ...


    Is that right ?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Exactly you are right now i just want to make my code to work fast Because it is very slow it takes 5 and more minutes to perform this calculations.


    and i have attached a sheet where it will paste and transpose in the sequence as i mentioned manually in the Sheet PasteData.


    Now there is just to things that i want to add in my code.


    Paste and Transpose sequence as available in the attached workbook and code speed issue.

  • Given the huge size, in my opinion ... macro has to be totally redesigned ...


    There are 79 years on a yearly basis ... plus 1 year ( year 2020 ) on a quarterly basis ...


    All of these ... is to be repeated 3 times for the different accounts:


    00202_0000
    00203_0000
    00204_0000


    Is my understanding correct ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)