J
jlbetz
I have attached my workbook so you can see what I am trying to do
basically I am reproducing a P&L in excel using a data dump, then usin
sumif and sumproduct to roll up the correct amounts to the correc
lines. This works on a company level, but I need to add a drop dow
box that allows the user to select a department, then the resulting P&
would only reflect the amounts for that department. In my workbook th
first tab is the detail, column A is the department, column B is th
account #, column's C thru N are the monthly amounts by department an
account #. The second tab is the P&L, I want to add a drop down lis
that allows the user to select a department at which time the P&L o
only that department would be displayed
Attachment filename: 2004 10300 actuals copy.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51165
basically I am reproducing a P&L in excel using a data dump, then usin
sumif and sumproduct to roll up the correct amounts to the correc
lines. This works on a company level, but I need to add a drop dow
box that allows the user to select a department, then the resulting P&
would only reflect the amounts for that department. In my workbook th
first tab is the detail, column A is the department, column B is th
account #, column's C thru N are the monthly amounts by department an
account #. The second tab is the P&L, I want to add a drop down lis
that allows the user to select a department at which time the P&L o
only that department would be displayed
Attachment filename: 2004 10300 actuals copy.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51165