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

    List box with restrictions based on user inputs. [SOLVED]

    Hello Champs, I have 3 list boxes (to select Country, State, District) linked to each other. Under “country list box”, I have a list of country names and when one gets selected it shows corresponding states under “state list box”. State list box also has a list of states which upon selecting...
  2. Sammy

    Update values in comments using VBA [SOLVED]

    Hello Champs! I have a dashboard that shows month to date and week to date information and there is not enough space to show all the values! Hence a slight problem for me. What I am looking for is to have a comment display the remaining information when a user hovers/selects the respective...
  3. Sammy

    Format Cells based on specific text

    Hello! I have a question that I couldn't find by searching through other posts and have been stuck on this problem for hours. I have a row in a worksheet in which the value in cell A12 (and A13, A14, A15 till A61) contains either "P", "D" or "". Based on the value under column "A" i would...
  4. Sammy

    How To Count The Number Of Rows Without Opening An Excel File!

    This might sound silly/crazy/plain laziness :). I have 30-40 .csv files that I open using Excel, each containing some numbers in row 'A'. Is there any way that we can take a count of the number of rows in each file and have it updated in a separate workbook? What I am doing right now is...
Back
Top