Guity,
Please send me your file at radooku at gmail dot com. You could also share the file through Google Docs. That way, we'll be able to collaborate in real-time.
As for your formula, you're absolutely right. When the case is AllProduct or AllPeriod, you could add a little IF formula...
What do you mean about "knowing anything about this dashboard"? Try and be more specific, because the more specific you are, the faster we can help you.
Cheers,
Radu
Guity,
I gave it a quick look :). What you could do, in terms of the help form:
1. if you're working on the template file: go to the HelpSheet, then replace/add help topics to your liking (hint: if you add another help topic, the form will be automatically updated to include it); the only...
Guity,
In order to create a user form, you will have to go to VBE, select Insert-User Form. This will create a blank user form. You will then have to insert controls and set control properties etc. You can also write code for each control in the form or for the form itself (double-click each...
Dean,
Sorry, the formula is
=IF(AND(ISERROR(MATCH("A";A1:F1;0));ISERROR(MATCH("V";A1:F1;0)));SUM(A1:F1);IF(NOT(ISERROR(MATCH("A";A1:F1;0)));"A";IF(NOT(ISERROR(MATCH("V";A1:F1;0)));"V";NA())))
Got a little careless there, at the end of my workday :-) Besides the fact that the formula will...
Hi,
In Excel 2007, in Pivot Table options - Display Tab - Field List. You have there 2 options: "Sort A to Z" and "Sort in Data Source order".
Hope this helps,
Radu
Hi,
Assuming you have the values in the range A1:A10, select the cells you want to format, go to Conditional Formatting-Color Scales-More Rules. Make sure you've highlighted the
"Format all cells based on their values" option. In the "edit the rule description" box:
- if you want to...
Hi,
To hide the numbers, just use the ;;; custom format. Then use a formula to link the cell you want the numbers to appear (for instance, assuming that you have your button linked to cell C5, format cell C5 as Custom - ";;;", then in another cell type =C5).
Regarding the radio button links...
Hi Hui,
Thanks for your quick response. The report is generated each time from a database and exported automatically in a new workbook, so there's no chance that a user will have a workbook already named after him.
Regarding the actions, I need to copy all the rows where the action was made...
Hi all,
I have (in Excel 2003) a report containing the actions made by some users in Sheet1, and the list of users that I need in Sheet2. Can anyone help me with some code that would:
1. Check, in Sheet1, the actions made by the users in the list in Sheet2;
2. Copy the entire rows where the...
zacpower,
try this, for the given criteria: =IF(AND(B2>0;B2<=7;C2<10%);"Really Bad";IF(AND(B2>0;B2<=7;C2>-10%;C2<10%);"Sort of Bad";IF(AND(B2>=8;B2<=15;C2>-10%;C2<10%);"Average";IF(AND(B2>=16;B2<=20;C2>20%);"Really Good";"N/A"))))
I...
Hi Hui,
Thanks for the advice, I will try to do without the VBA. Like you said, there's no point in having multiple versions of the same report, or make the project error prone.
Have a great one,
Radu
Hi all,
I have a weekly report that I've chosen to reformat using a dashboard approach. All the sheets in my report have combo box form controls that show the start and end of week dates (for instance, 22.02.2010 - 28.02.2010). What I would like is that when the user chooses another week in...
Hi Richard, and welcome!
I've had the same problem some time ago, and in my case I've managed to solve it by adding a new sheet called "Instructions", in which I've explained to people exactly what I wanted them to do. Maybe this could work for you too...
In any case, you could use in another...
Hi. Maybe you could pick up some ideas from this: http://www.processtrends.com/pg_chart_scroll_bar_checkbox.htm or this: http://www.processtrends.com/pg_dynamic_charts.htm. Or, you could go with applying data filters to your source data, like here...
Hi. Here's an idea: if you're using Excel 2003, go to the Tools - Options menu, in the Edit tab, and see if the "Edit directly in cell" box is checked. If it isn't, check it and you should be home free :D Let me know if it works.
Have a great one!