• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Profit and loss table

S

Soul

New Member
Hi,

I am currently reporting for several departments, and I wish to create a dynamic P&L by using macros. At the moment, I have several sheets which has P&L for each sections. I have already created a dropdown menu for each section, but I am unable to create one sheet which can identify the different sections. Can anyone help me out here?


Cheers!


Please have a look at the attached file:

http://www.2shared.com/file/E5EvCg3M/Monthly_Account_-_test.html


Furthermore, the sheets marked in red is the way I wish to have my profit and loss.
 
Have you had a look at: http://chandoo.org/wp/2011/09/14/hui%E2%80%99s-excel-report-printer/
 
Hui,


Thanks for your reply. That is an interesting formula, however that is not what I am exactly looking for. I basically want to create P&L for each sections/ departments by using VBA.
 
You must log in or register to reply here.
Back
Top