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.
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.