Excel Balance Sheet Generate Table via VBA/Macros
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
This macro assumes that you have a second sheet ("Consolidated Balance Sheet") that already contains the Consolidated Balance Sheet table starting in Cell A1 with no formulae or numbers, only the text. Before trying this macro, change the sheet name (in red) to suit your needs.
Please Login or Register to view this content.
Last edited by Mumps1; 04-25-2024 at 12:17 PM.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thank you for the help, Mumps1
Have a great day and enjoyable weekend!
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks