Replies

I think I see why I’ve been having problems with this. I click on the “Control Properties” button, but I don’t see those properties that you list in any of the tabs that come up. the Control tab only has Input Range, Cell Link and Drop Down Lines as an option. The “Prpperties” tag only gives me options for Object Positioning and a check box for Print Object.

To creat the box, I am using the Combo Box option in the Forms box. Should I be creating the box from another toolbar or from somewhere in the menu lists?

I really appreciate you all helping me with this problem. I’m usually pretty slick about these things, but I don’t seem to be on the same page as you guys.

This will definitely work for me. But I need more specific instructions on how to create this because I have very little experience with combo boxes. I know how to create the box (click on the button, drag cursor where the box is to go, click on it to move and resize), but once the box is created, how do I link it to the array so that it will show only the Friendly Description column, and that the cell will reflect the obnoxious box?

Thank you so much, this did the trick! I apologize for waiting so long to post a response, I’ve been swamped at work. It really truly sucks when I actually have to work at work.

The end product of these tables are going to be posted on our company Rep Room, and each rep will only be able to see their own numbers. The problem that I have is getting them on the web and only allowing the people to see their own individual chart.

THANK YOU! This does exactly what I want!

Thanks Steve and Hans! That formula is working great! I don’t use if-then formulas often and always get confused about the protocols when I start doing multiples If’s in a formula. I really appreciate the help.

Ok, that makes total sense. To answer your question, I need the formula to show 0 as a result any time that the first date and the second date are the same, regardless if they are a weekday or a weekend. In other words, if the customer request date (Column is the same as our scheduled delivery date (Column C), then we were able to meet the customer’s objectives which should reflect as a 0 on the report. What formula modifications do I need to make? Or should I use a different formula?

Also, I have one If-Then formula in cell G17 of my attached document. I need to add a second If Then statement in the formula for instances such as this one where there is no request date. Here is the longhand version of what I need the formula to do:

If the request date is null, then “No Req Date “[NOTE: Can I include a space here before the quotes, in case both sets of text end up in the formula?]; also if the Date Shipped is null, then “Not Shipped”; otherwise NETWORKDAYS (D,B,Holidays!$A$4:$A$!!)

I’m not sure if there will be any instances where there is no Request Date and no Ship Date, but I need it to have both of those default texts in there for both instances.

That worked perfectly, thank you!

That worked perfectly, thank you!

Thank you! Adding a hidden object was a great idea. I’m in the middle of creating the Org Chart from Hades. I’m creating links that allow drill-down through the PP presentation, but I’m having to use text boxes and connectors instead of the standard pre-formatted Org Chart that comes with PP.

One set of data is in boxes with a blue background and white letters, and the subordinates are in a light blue box with black letters. Using your idea, what I’ve done is set my format for hyperlinks to be black both before and after they are selected so I can set normal hyperlinks in the subordinate boxes, but I added blank boxes over the manager’s names (over the white text on the blue background) so that when they click the name, they get moved to the manager’s slide. That way I can keep the font the same and have hyperlinks with two different colors.

Thank you! Adding a hidden object was a great idea. I’m in the middle of creating the Org Chart from Hades. I’m creating links that allow drill-down through the PP presentation, but I’m having to use text boxes and connectors instead of the standard pre-formatted Org Chart that comes with PP.

One set of data is in boxes with a blue background and white letters, and the subordinates are in a light blue box with black letters. Using your idea, what I’ve done is set my format for hyperlinks to be black both before and after they are selected so I can set normal hyperlinks in the subordinate boxes, but I added blank boxes over the manager’s names (over the white text on the blue background) so that when they click the name, they get moved to the manager’s slide. That way I can keep the font the same and have hyperlinks with two different colors.

Thank you! I’ll read my Excel book about Data validation and check out the Help page to figure out the details about how to use this feature. At least now I have a point of reference.

Thank you! I’ll read my Excel book about Data validation and check out the Help page to figure out the details about how to use this feature. At least now I have a point of reference.