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

Create Chart based on condition

coolkiran

Member
I am creating a Excel application. I am in final stage. Now i want some suggestions.

I have uploaded sample file for reference.

There are three sheets, Home page, Template and Test. Ignore Template sheet.

In Home page, i have drop down where i can select sheet. and in next drop down I have added some items like COGS, Sales, Sales detail, COGS detail and All.

What I am trying to do is, if I selected a sheet, and one item for example, Sales, macro needs to go that sheet and for sales, I need to copy from row 3-6 and paste it in either Home page sheet or new sheet. I think this we can achieve it. But main problem is, I want a comparison chart, that will show the difference between, P/L actual budget and P/L Budget May 2014 (In my example file ).

Same thing for other items Sales detail (Row 15-22), COGS detail (Row 25-28).

Is that possible?
 

Attachments

  • test.xlsm
    45.3 KB · Views: 6
Hello Again

I have simplified my file by adding pivot table. But again, one small part is not working, i wanted to put filter for Values (Row Labels) since i need to check Sales, COGS ... etc.

Any suggestion.
 

Attachments

  • PL.xls
    43 KB · Views: 3
Back
Top