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 "Smiley" icon, 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 "Smiley" icon, below, in the bottom right corner :)

  • Thanks for the clarification ...


    Will draft ... your Version 7 ...

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

  • Thank you sooo much Carim FOR THIS GREAT HELP.


    Pleased to hear it seems to be finally ...sorted out ...!!!:)


    Thanks a lot for YOUR Thanks ... AND ... for the Like :thumbup:

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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!