VBA Code Transpose with dynamic range column

Hello, morning.


I would like to know if is it possible to make a code that could fit in the attached cenario.

I need a code that could transform column a into the other columns, as follow the attached archive.

(Acc xxx) -> refers to the account number
(Ref xxx) -> refers to the payment/receive reference of the previous row (for example: A4 Ref code, refers to the value in A3 cell).
(Saldo xxx) -> refers to the actual balance of the previous row (Acc xxx) (for example: A9 "Saldo", refers to the balance of account in A2 cell.)


The code i'm looking for, should "transpose" the column A into the format of columns/rows of the range "C:P", as follow the example attached.


The ranges between the (Acc xxx) and it's (Saldo xxx) are dynamic, so they can have more/less payments/receives and their refs, or no payments/receives as the example in the cells A17 and A18, where there's just the "Acc xxx" and it actual balance "Saldo xxx".

Ignore the first row in the document attached. I just created ir to indicate from/to of what I need the code to do.

Thank you very much in advance!

1663941561-Pasta-de-trabalho-1.xlsx

Hi & welcome to the forum,

Try below code ... Data will pasted from cell [C15] which you can change

Please Login or Register  to view this content.