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