Search results

Hi vinwin06, Can you plz download the file from here? http://speedy.sh/tF3Ev/Sample-Graph-2-updated.xlsm As I could see that you have put filter at row 18 and select a particular month, I assume that you want to see the chart for a particular month. If this is your requirement then we can...

Hello Dr. Bob, Welcome to Chandoo. org forum. Your requirement can certainly be achieved using excel (as Narayan said). Regarding accessing the same from smartphone is something I have some idea about. I do work in pharmaceutical field where we design such interactive tools and make them...

Hi Nine, First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here. As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and...

Hi vinwin06, I provided the code in that way as you wanted to paste the comments in some other column (according to your last post). However, thank you for providing the clarification. If your comments are at row 14 (always), then we can directly change the row reference number in the...

Hi vinwin06, According to your suggested change in the chart data layout, I have modified the code again in order to meet your requirements. Below here is the modified version of the code: Private Sub Chart_Mousedown(ByVal Button As Long, ByVal Shift As Long, _ ByVal x As Long, ByVal y As...

Hi vinwin06, Glad to hear from you again... I do understand your concern but not sure where you actually want to paste the vlookup-ed data(comments)....I mean to say in which sheet...which column etc... I assume, you want to paste the data on sheet2 from A2 onwards(A1 is header). Please...

Hi Harry, I have one doubt regarding your question. Your data validation( with four options as you specified) is at A1, and you want row 1-23 to be hidden when you select Personal loan. In that case, your data validation cell will also be hidden!...so I have little disconnect here. You...

Hi Harry, Unfortunately I missed your further post and sorry as I did not catch you other criteria/requirement(if nothing is selected)... But, meanwhile, I could see that people have already replied to that (with formula and UDF approach). Please advise in case of any issue. Kaushik

Good Morning cacos, Downloaded the file but not able to understand the conditions you have specified. I understand that you are trying to create dependent drop down list but I am not able to comprehend the conditions(you have explained) to be applied. Can you plz answer my below question...

Hi Rana, Thank you for your explanation abut confusion still persists!! In point number one you have said that: 1)You have created two named ranges Catagory and Item in look up sheet, however, I could see only "category" but no "item". But I assume, you refer Col C as "item" named range...

Hi HARRY, I assume you have 5 elements: Apple, Mango, Banana, Orange, Pinepple. Your conditions are as follows: IF A1= Apple THEN B1= Good IF A1= Mango THEN B1= Better IF A1= Banana THEN B1= Best IF A1= Orange THEN B1= Bad IF A1= Pinepple THEN B1= Worse To do the same plz follow the...