• 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. I

    Protect the cells with only selection access no modification...

    Thanks Dave.. this is also a nice.. idea.. but i dnt know.. which event Ive to written that code.. thanks .
  2. I

    Protect the cells with only selection access no modification...

    Superbbbbbbbbbb,,,, Narayan... This is the thing I want....Great.... Simplest.. way.. Thanks... Thanks a ton... I'll do. that.. :)
  3. I

    Protect the cells with only selection access no modification...

    I have a Protected Excel Dashboard in a Sheet that has some unlocked cells,and those cells have some count(numbers). I have written a macro on 'sheet double click event' If doubleclick on the particular unlocked cell that will take you to the another data sheet and it will automatically filter...
  4. I

    Ctrl + V has stopped working for some worksheets in Excel 2010

    Please check if any macros that assigned to this Ctrl+V as shortcut key.....
  5. I

    Combo box with All option

    Thanks a lot Hui!, even I was thinking in the same simple method.. but tried here for some other esay method.. if possible.. .. because Ive used loads of formula in my file for multiple dashboards.. The file size is 35 MB now.. then I saved it in the Excel Binary format.. now its reduced to 15...
  6. I

    Combo box with All option

    I have two combo boxes year and Location.. based on that Im using Sumifs() funtion to calculate the Total Sales. But now I need a option in the Location Combo box 'All', if I select All it should calculate all the Total based on the selected year only. (Like Pivot Table's All option) For...
  7. I

    @ Key issue in an Excel file

    In a particular excel file if press "@" key it displays """ key and viseversa.. Im so confused .. please help... other excel files and another files my keyboard works properly... except this file...
  8. I

    LookUp using Multiple Condition

    A B C D E VENDOR BRICK MRP TAX CODE Margin Chandoo ACC 548 Hui 4284 519 Shri APPR 550 Narayan V12.5 637 Narayan V12.5 637 Hui 4447 519 Chandoo JEW 786 Hui 4266...
  9. I

    n.... no. of dates?

    Use Text(value,Format text) formula. . If you have the date in A1 in the new field type =text(a1,"MMM'YY") thats it.
  10. I

    assign data in the Inserted picture.

    Thanks a lot..Luke.. its done.. I was really confused... now clear... Thanks..
  11. I

    assign data in the Inserted picture.

    Thanks a lot..Luke.. its done.. I was really confused... now clear... Thanks..
  12. I

    assign data in the Inserted picture.

    How to assign data in the Inserted Picture.. Im using Excel-2007 and Im trying to display the calendar view (cell range a1:G6) in the in the picture view.by selecting the picture and typing '=Sheet1!$A$1:$G$6' in the formula bar. but its not displaying the value properly... it is displaying only...
Back
Top