Dear Guys,

I am just start learning VBA from the beginner and really frustrating on convert excel formulas to VBA.

I would like to Generate a "Consolidated Balance Sheet" table (right side) from the raw Balance Sheet data on the left via VBA.

Is it possible to do that?

excel forum.jpg

I also attached the excel spreadsheet for the references.

I'm extremely appreciate if someone can help.

Sample.xlsx

Thank you