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 ?
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 ?
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 ...???
just for this
00202_0000
Yeah i know my code is not much advance but it have to change.
Thanks for the clarification ...
Will draft ... your Version 7 ...
Attached is your Version 7 test file
Hope this will help
Thank you sooo much Carim FOR THIS GREAT HELP.
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
Don’t have an account yet? Register yourself now and be a part of our community!