Copy Paste the Missing Values in a Specified Cells and Insert the Rows into a Report

Hi All,
I am new to this forum and this is my first question. I am facing a unique problem in ledger listing, While ledger listing, some of the account codes are missing, i have listed in the q r column respectively.
I would like this missing values to be copied and paste it to U12 and V12 cells and copy rows u12 to af14 and paste it into the report in proper sequence which is displayed left side one by one till all the misssing values copied.

I have attached the sample file for reference

Any help appreciated Thanks jude

Thanks a Lot, Pierre, it works perfectly. You have done its fast. It was quiet challenging one.
Great.

Hi Pierre,

I am facing another kind of challenge in the code, apparently its copying the blank cells along with the format when the missing values are nil.

Any thoughts how i can overcome this issue?

Kind Regards
Jude

Thanks Pierre its fine now, I have addded the if condition along with your code (missing ledger) to find if its zero, it works now.

Kind Regards
Jude