Recent content by rks

Hi Faseeh, I am plotting a pie chart directly form a pivot table in excel 2004

Hi, I have a pivot table with country name on one column and corresponding count of products on another column. I have plotted pie chart for the same which gets updated with changes each time i refresh the pivot table.I have declared country names as a dynamic range list in another sheet(...

Hi Narayank , I tried this code. Since i am working in Mac machine when i run the above VBA code, it gives me error showing that the line :Application.SendKeys ("%{DOWN}") is not supported in Mac. Kindly help

Hi Luke, I am not clear on the pivot table could you kindly let me know what needs to be done on the scenario shown in sheet. Also does pivot table consider formulas

Hi, I have two tables one in sheet 1(table 1-Controlling table) and another in sheet 2( table 2). Kindly see the attached sheet: https://www.dropbox.com/s/wzvljbi7mhzt2nn/table.xls The Count column in table 2 has sumproduct formula eg...

Hi, Also i would need the monthly sheets to look replica of yearly sheet except that it should contain data from Jan 1st to Jan 31. Similarly Feb sheet should contain data from Feb 1st to Feb 29 and so on. Pivot table would truncate the field names.

Could you kindly let me know how can it be done for data on this sheet, as am new to excel and am unable to figure out.

Hi , I am working on a enquiry tracking sheet which has tabs Jan to Dec, Yearly enquiry list, Q1-Q4 graphs and Yearly graph . I have included a sample copy of the original sheet( which has more columns and data, but is confidential). A sample has been uploaded at the below link for more...

Hi , I am working on a enquiry tracking sheet which has tabs Jan to Dec, Yearly enquiry list, Q1-Q4 graphs and Yearly graph . I have included a sample copy of the original sheet( which has more columns and data, but is confidential). A sample has been uploaded at the below link for more...

Thanks Narayank. Could you kindly upload the sample workbook

The first part is working perfectly fine. Thanks a ton. Kindly let me know if there are any other way to display "Not applicable" other than using the code( as am a starter and finding it difficult to use Macros)

Hi Narayan991,thanks for your suggestion. I tried your suggestion,( not yet the VBA code). I named two ranges as Zone_List and other as Not_Applicable suggested by you. However when i enter other countries, it directly shows Not applicable( which is fine). But when i enter "India", it shows...

Hi Bobhc, creating a drop down list with pre-defined country names is difficult as it is not possible to predict the country from which we get request.

Hi Bobhc. Thanks for that. My problem is Column A does not have a dropdown list. The country name is manually entered. If it's India then adjacent cell B shows a dropdown list( North ,South, east and West). Else it displays a text "Not Applicable" in Column B for any country entered manually.

Hi Indian, had done that but did not find any suitable answer