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

    Drop down list options

    That worked. Thanks. And I'll start a new thread next time.
  2. K

    Drop down list options

    I am having a similar issue with basically the same set-up in a table. Pull down menu in a cell with four number options. If the user picks number 2 the a pop-up window opens. Works great until I add a row in the table. Immediately get run-time error 13, but the pop-up window still works...
  3. K

    Extract Month and Year from a Date cell

    Worked perfect. Thank you.
  4. K

    Extract Month and Year from a Date cell

    Please help. I would like to use MONTH and Year functions and pull from a cell with month day and year. I would also like to combine the functions with text. Example: Cell A1: 01/12/2013 Want cell B1 to return BANK RECONCILIATION - JANUARY 2013 I can get either the month or the year...
  5. K

    SUM won't fill down to new table row

    Nevermind. I think I have it all figured out now.
  6. K

    SUM won't fill down to new table row

    Thank you Bobhc. I think I figured it out while you were answering. I reapplied the formula to the entire table column instead of just highlighting a range and it works. That creates a different problem though because the first value in my columns is a balance forward and I want it ignored...
  7. K

    SUM won't fill down to new table row

    It seems I'm having the same problem on other sheets as well. Some formulas copy down some do not. My Data Validation List and an IF formula don't fill down, in another sheet one of my SUM formulas doesn't fill down, but another one does and the formula cell references have changes causing it...
  8. K

    SUM won't fill down to new table row

    I have a table with a column for a running balance. When I get to the last data cell in my table and tab to enter a new line, all the formulas fill down except the running balance. There is a SUM formula in the column next to it that fills down just fine. Column L fills down...
Back
Top