Hi,
I'm Soul from Norway, and I'm currenty working for an international oil, gas and shipping firm, where excel is an import tool in my everday work. Thanks to this site, my excel skills has improved significantly. Keep the good tips coming guys :)
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.
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...