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

    Thank You, Thank You

    Hello I have been using this Help Site alot in the last week and want to thank those that have responded to my queries. I am a newbie with all these functions but, am learning thanks to your help. Hopefully, I soon will be able to give back instead of taking all the time. Thanks again, I...
  2. S

    Dynamic Function Does Not Work When Worksheet is Protected and/or Cell Bolded

    Hello everyone I have built this spreadsheet using a table from Row 20 on. By selecting cell A21 and pulling on the lower right corner, I am able to add more rows with the formulas intact. I have also created a dynamic print range and the sums in Cells O5, E12 & E13 are dynamic also but...
  3. S

    How to Best Match Manual Calculator Calculations to MS Excel Calculations

    Hi Everyone You will see from the enclosed that the formula for O21 is as follows: ((N21*J21)-(N21*J21)*L21))). You will also see the the Excel calculation total vs my calculator total is $499.44 vs $499.80 and $445.72 vs $445.49 for Cells O21 and O23. The manually calculated total must be...
  4. S

    A Better Way to Show an Error in the Calculation??

    I have highlighted the two columns in question in pink. In the first, the Total ACV & Replacement Cost quantities cannot exceed the Total Item Qty. The second, is the a manual entry in the Replacement Cost cell cannot be greater than the Estimated Replacement Cost. I appreciate any feedback...
  5. S

    Best Way to Set Print Area So That It Includes Any Row Inserts

    I am pretty proud of the enclosed file but, end user is concerned about having to set the print area for each project. Is there a way I can simplify that for him? http://www.2shared.com/file/2bwiSgPQ/CVR-Test_2012_12_08.html
  6. S

    Cannot Insert Rows / How to Insert Rows So That Formulas Copy

    1) I need to insert rows from the blue highlighted line down but, I keep getting the error message that you will get also. I have gone to CtrlEnd many times but it does not go ahead. 2) I need to know how to insert a line and have the previous lines' formula's copy as well. Also, is there a way...
  7. S

    Creating Custom Screens with Userform

    A colleague shared with me the enclosed file and wanted me to duplicate the "Add Lines" macro it contains. At least I recognize what it is but, need guidance on even where to start. Can someone walk me through it? Here is the download link to the file. Also, it is in .xls format and I wish to...
  8. S

    Line Chart with 2 Data Series

    I need to create a graph with 2 different series of data. One is for the entire production period (Jan-Dec) and the second is for the production period Jan-Jun for which I need to forcast a trend. The thing is that when I create the second series, excel graphs starting from "0" instead of the...
Back
Top