Search results

Thanks. I'll amend it further to suit my needs.

I have cell A1 (named ObjTotal) which is sum of B1, B3, B5, B7. If A1 is <100 or >100, then I want to have a Message Box telling the user, to change the value of the B1, B3, B5 or B7 such that the sum = 100. How can I write a VBA for this. TIA. Regards, Ninad.

@Meedan: I'll upload a sample file tomorrow

I need to do aging analysis of issues raised during internal audits. I have a sheet with all the required fields one of which is the "days". I usually did the aging for 0-30, 31-60, 61-90 and so on as per my "wish". I used nested IFs to achieve this which is then used as data source for a pivot...

Hui, For every ElseIf, I thank you. I shall study this code to help me increase my VBA knowledge. Regards, Ninad.

Googling gave the below. http://ss64.com/office/ http://www.exceluser.com/tools/benford_xl11.htm

Thanks of responding Hui. For future graphs I can follow as per the post link you provided. However, for the current set of graphs it's too much of a hassle to redo them. Hence, my request as in the first post. I am not well versed with Excel VB, but hte logic is pretty clear to me for...

Hi, I have PLENTY of charts in one workbook which are the same, except that the data ranges are different (same X-axis and same number of series and type). Since I do not want to physically check each graph for the range (just to make sure there's no error in a wrong range being selected)...

May be I'll just make all graphs that way and get the higher ups to see differently ;). Have a great day.

No offence meant Luke. But too many of those bands on the page will make me color blind some day. But I have to go with it. I did go through Jon's blogs and have finalised which metrics will be displayed as stacked bar and line combo graphs and bullet charts for the others, whilst some will be...

@Hui: Yes, I've considered bullet charts too. I wanted to get a feel from the members for their view point as well. @Jesse: That's exactly what I did for one graph. Yet to make up my mind.

For some reasons, the metrics for our performance measures are set into bandwidths and one example is Unsatisfactory <=19%, Acceptable >=20% and <=29%, Excellent >=30%. The data is captured and represented either monthly / quarterly. What is the best way to represent this...

Does work like a charm. Thanks Vijay. Calculation mode needs to be set to "Automatic"

Hi Vijay, Thanks. Will change the drop down to Forms Control. If you do get the answer to ActiveX refresh, please do enlighten me as well. Have a great day. Ninad.

Hope this works. http://cid-ef586da077d21a56.office.live.com/browse.aspx/.Public

How do I attach a file ?

In the file I have the values for the combo box for sheet "6a" stored in the worksheet "Weightages" in a range named "Scores" (cells C29:C49). Based on the cell value E73 in worksheet 6a, I want to control the list values in the drop down as seen in rows 97 and 101 only. For e.g. if E73 is 30...

Hi Luke, Thanks. Solves a lot of trouble for me. Ninad.

@Chandoo: I like the use of the word "simple". Can you help. Or provide a direction towards the macro/VBA. @Jesse: The cells need not be adjacent as you rightly understood. I'll try what you have posted and report back.

I would like to Add the data in 2 or 3 or 4 cells into a single cell and Concatenate or using the "&" will work fine if the result was in another cell. E.g. if A1 = "the", B1 = "Big" and C1 = "Fight" then Cancatenate or "&" in D1 will give the result "the big fight". How do I achieve this same...

Thanks for the response Kevin. I'll try it out and post a feedback in a couple of days. The blanks I can live with as long as they cannot be selected. Have a great 2011. Cheers. Ninad.

I have a combo box called "cmbTotal" (ActiveX control and not Forms) with list values 0,5,10,15,20,............100 which is a range named Scores. Based on a cell "A1" with range name TrendLimitValue which can take value from 0,5,10,15,20,............100, I want to limit the choice the list of...

http://www.cpearson.com/excel/topic.aspx amongst the many others listed above.

Thanks. That did it. Any idea how that might written as a function/addin such that I don't have to copy/paste the whole formula time and again.

Hi, I am based in Dubai where Friday and Saturday are the weekly Offs. Some have only Fridays. Networkdays calculates working days with Sat/Sun as Offs. Can someone document a function to incorporate Fri/Sat as Offs AND Fri as Off. To make it really flexible, a function outputting the...