• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Datavalidation help: change value based on another datavalidation

    Hi All, I have a named range as datavalidation in one cell and in another range I have the same named range. I would like to change the second data validation based on first one. Eg: In Cell A1 I have first data validation and in B2 i have second data validation. Both of them have same...
  2. D

    Need help in Getting the selected items of a Pivot table filter

    Hi All, I need help in getting the selected items from a pivot table report filter. I have Country field in my report filter and I have multiple selections . I want to get through code what are the selections made by user. I am attaching a screenshot for reference.
  3. D

    Help required to Rank Numbers Positive to Negative

    Hey All, I have a scenario where I have to rank positive to negative and also to ignore zero's. I have attached a sample workbook. Any help would be much appreciated. -Dinesh Download link for sample wbk: http://www.fileconvoy.com/dfl.php?id=gd08bec0452a32e45999269815da70cd365334f4c5
  4. D

    Need help Downloading a file from Webpage using VBA

    Hi All, I have written a module to login into a webpage, do some operations to pull a report using VBA. I need help in downloading the file in IE. When i click the download option a pop window opens and I am not sure how to connect it in VBA. Thanks in advance. Thanks, Dinesh
  5. D

    Pivot table Show only one option

    Hi, I have a set of data which has a column with years eg:2001,2002..20110. I would like to show only 2010 in the report filter. Is there any way to do this? -Dinesh
  6. D

    Sort Text

    I went through the forum and viewed text sorting using formula's but could not get.. What I would like to do is I have a list if text as below A Z D B C To A B C Z D I want to sort it to in ascending order Except D as i always want this in last .
  7. D

    Excel Add-In not working in Windows 7

    Recently my system got upgraded to Windows 7, My addin is loaded and it shows in the ribbon but when I click nothing is happening. I have enabled all macros in trust center settings. I am using Win 7 & Excel 2007(Addin developed in 2007 with XP). Please let me know if you have any solutions.
  8. D

    Interdependent combo list

    I have created a dependent combo box (Form controls). I am filling the data for the combo boxes using named ranges.Each combo box is lined to a cell to get the index. The problem I am facing is the cell link(for Country) is not updating when the combo box has only one value. I have sample...
Back
Top